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