Hi,

To extract the even rows put this in b1 and drag down

=IF(MOD(ROW(A1),2)=0,A1,"")

and in c1 and drag down for the odd rows

=IF(MOD(ROW(A1),2)=1,A1,"")

Mike


"Jan" wrote:

Hello.

I have data in ONE column in every row and would like to have TWO
columns with the same data, but in first column all of the odd rows of
the FIRST column and in the second column all of the even rows of the
FIRST column.
Can someone tell me how to do it?
Thanks for your time and help.
Jan