Hi folks,

I'm working with spreadsheets that are 6 columns and about 120k rows. The first row are headings and so the data starts in A2. I need to take every 10th row of data to create six new columns adjacent to the original data (starting in column J or so). Also, I'm taking every 10th row starting in row 6 (which is actually the 5th row of data due to the headings) so the sample is 6, 16, 26, ect.

Any idea how to do this?!? I've played around with the INDEX function a little bit and came up with something like this:

=INDEX(A:F,6,1)

However, it autofills across ok, but just copies the same row when I try to fill down. Any help is greatly appreciated. Thanks!

Josh