How do I select all the even rows in a worksheet and move them.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

What I am trying to do is select every even row in a worksheet and move them
to another part of the worksheet, deleting the rows after they are moved. I
basically have two spreadsheets that have been put together and I need to
seperate them. The easiest way I can explain it is A1's data starts on A3,
and A2's Data start on A4, and so one for each column.
 
I think you will get a lot of possible solutions to this but I like

1) add another column
2) use this function =MOD(ROW(),2) exactly as I have written it. Extend
downwards.
3) use data>autofilter to select for 1s or 0s
4) Copy
5) paste on new sheet
6) delete the rows from the original sheet without removing the autofilter.
It leaves you with the ones you didn't delete
 
Back
Top