I have a spreadsheet with only one column (A) with 3,500 rows of data. Each seven rows of data describes one product and there are 500 products.

How do I set up a macro to cut/copy each group of seven rows of column A and move/paste them to a new sheet so I have 7 rows by 500 columns, with each column containing data about each individual product?

Any help would be greatly appreciated.

TIA,

Guy
MS Excel for Mac 2008