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

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

=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

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

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