I use an additional column.

I put A in row 1 and B in row 2
I select the cells in x1:X2 (say)
and then copy down as far as I need

Then I apply data|filter|autofilter
show only the A's (or show only the B's) and
copy the visible rows
and paste to the new worksheet.

wrote:

I'm trying to select every other row of data (2,4,6,8, etc) and move
these to a new column. What is the simplest and quickest way of doing
this?

--

Dave Peterson