removing blanks

[Keith.Jackson]

I have a column of 100 rows . There are 10 values randomly interspersed in those rows with 90 blank spaces. I want to put the 10 values in a column of 10 rows with no blanks in no particular order. Does anyone know code that would do this.?
The sort method is not appropriate for what I'm trying to do.
Thanks

 

[Norie]

Keith

Why not just select the column, goto Edit>Goto...Special... and select blanks.

Then delete the blanks.