Removing blanks from a drop down list

[Ohrdhor]

I've been creating dynamic lists (defining a column and using that) however they are filled with massive blank spots (probably from the unused cells in the range) and i've turned on ignore blank, any idea how to fix this small problem?

Thanks a lot guys!

 

[SteveO59L]

Filter for blanks, then delete

 

[Ohrdhor]

Filtering for blanks makes the entire sheet jump down to ~225, and I'm unsure of what you meant by delete. I'm not trying to be problematic, but my grasp of this program is extremely lacking.