Excel, group a number of rows into columns
Solution 1:
If the values are in A1:A616 (or any number of rows) here's a formulaic way to reorganize them. Put this formula (don't edit it) in any cell off to the right and copy it 9 columns wide, then down as far as you need to until all your data is done:
=INDEX($A:$A, COLUMN(A1)+(ROW(A1)*9-9))
Notice the two 9s at the end, you can change that to any number of columns.
