call us today: 1.800.876.8376
email us: info@synergy.com
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() mod 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.


Mark as helpful.
0

Posted in: Formula Entry: Advanced formulas