Assuming your FIRST column is Column A, and your data starts in Row 1, enter
this formula in B1:

=INDIRECT("A"&(ROW()*2)-1)

Then enter this formula in C1:

=INDIRECT("A"&(ROW()+1)*2-2)

Copy both of these formulas down as far as you need.

Then, select all of your data in Columns B and C. Copy. Then, while B and
C are still selected, choose "Paste Special" from the Edit Menu. Check the
"Values" option. Click OK.

Now, delete column A. Your data should now be separated into the two
columns the way you wanted.

HTH,
Elkar


"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