If you dont want to keep the sort order then select the column and sort it.
OR
Select the column rangePress F5From Goto window select blanks.OKThen
right clickDeleteShift cells up.


If this post helps click Yes
---------------
Jacob Skaria


"sam" wrote:

hi everyone

here is my problem and i am sure there is a simple solution. i have a 1
column of data (text) and i want to transfer it to another column but remove
the blanks. can anyone help?

cheers

sam