Sam; forgot to mention that the formula in B2 is to be copied down....

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


"sam" wrote:

jacob

thanks for teh quick reply. there are no duplicates just blanks. here is a
rough example of what the raw data looks like.

----A
1--car
2--
3--dog
4--cat
5--
6--house

the end result i am chasing is
----B
1--car
2--dog
3--cat
4--house

cheers

sam

"Jacob Skaria" wrote:

Without a reference column it would be difficult especially when you have
duplicate entries in your data

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


"sam" wrote:

Jacob

I was more thinking of a formula that will create a new list just without
the blanks. i want it to change when i make ammendments to the primary data.

cheers

sam

"Jacob Skaria" wrote:

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