How do I take an input column and have every X rows stored in a separate column?

If you want to take an input column and have every X rows stored in a separate column, use one of the following formulas:

cell(index(), int(index()/n) + (col + 1)) = cell(index(), col)

where n is the number of rows in each group and col is the output column number. Using this formula, the data will be in the same row as the original data.

cell(index() % n, int(index()/n) + (col + 1)) = cell(index(), col)

where n is the number of rows in each group and col is the output column number. Using this formula, the data will be placed at the top of the data window. The % operator performs the mod function.

Scroll to Top