You can add an auxilary column and sort like this

1) Put in a new column in the 1st 8 rows the number 1 to 8. Then copy the
numbers 1 to 8 down the entire new column.
2) Sort on the new column.
3) All The data you are looking for is now on adjacent rows.

"jdpf" wrote:

How can I select the data in non adjacent rows of a column (eg. A1, A9. A17.
A25.......A800, A 808, A816 etc.) and place it into another column? The data
I need to select is consistently 8 rows apart in a very large spreadsheet. I
am using Excel 2003.