How do I copy/paste odd or even rows from Exel?

G

GM

I have a 10,000 record list in Excel.
I want to separate the list by odd and even rows. How can I do that?

Thank you,

Gabriela
 
R

RagDyer

You didn't mention how many fields you have.

With data starting in A1,

For *even* rows, enter this anywhere and copy down as needed:

=INDEX(A:A,2*ROWS($1:1))

For *odd* rows, enter this anywhere and copy down as needed:

=INDEX(A:A,2*ROWS($1:1)-1)

Post back if you need to copy additional fields across columns.
 
M

Max

GM said:
I have a 10,000 record list in Excel.
I want to separate the list by odd and even rows. How can I do that?
Click to expand...

One way ..

Assume data in cols A to D, from row2 down
Enter a label in E1, Enter in E2: x, Input in E3: o
Select E2:E3, fill down to the last row of data
Then just do a Data > Filter > Autofilter on col E
Filter out "x" from droplist in E1, copy filtered rows & paste elsewhere
Repeat with filter for: "o"
 
Top