The INT functions are, of course, unnecessary.
--
David Biddulph

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
=OFFSET(A$1,2*INT(ROW()-ROW(A$1)),0) for yoir odd column
=OFFSET(A$2,2*INT(ROW()-ROW(A$1)),0) for your even column
--
David Biddulph

"Jan" wrote in message
ups.com...
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