Dave, Thanks for the help. I must be doing something wrong as B1 and C1 fill
in correctly however when I select both columns and copy then paste
special/values, the values for B1 and C1 are repeated for all cells. What am
I doing wrong?

Thanks
dave H.

"DaHou" wrote:

I have column of x,y data where A1 is an x value and A2 a y ,then A3 is an x
A4 a y etc. There are several hundred values. I'd like to be able to parse
out all the y values in the 1st column, place them in a second column, then
remove the blank cells in both columns so that the x and y data are aligned
in two separate columns.

Any tips will be greatly appreciated.
DaHou