Don't paste empty cells???

[Robbie_Digital]

I have a column, in which maybe 10% of the cells have vlues in, and the rest are blank, how would I go about pasting the values into a new column which just puts all the cells with values one above the other at the top of the column.
Thanks

[davesexcel]

Are you able to sort the column before you copy and paste?

Check out this site on deleting blank rows

http://www.cpearson.com/excel/deleting.htm