Data Extraction

[rohit__mehta]

Suppose i have a set of data in a column, some random data. I want to take the data after every 60th row and put it in a different column. How do it do it?

For example i have 3600 values in a column. My next column will have just 60 values. I would like to take every value in the 60th row and put it in a separate column.

 

[MarcelBeug]

Suppose your data starts in A2, then enter in B2 and copy down:

=INDEX($A$2:$A$3601,60*(ROW(B2)-ROW(B$2)+1))