I have 1 column with about 31,000 rows. I need to break this up into rows that contain exactly 96 columns.


On a smaller scale it would look like this:

1 _ 1 2 3
2 _ 4 5 6
3 _ 7 8 9
4 _
5 _
6 _
7 _
8 _
9 _


The closest I've come is by using an offset formula: =OFFSET($A$1,(ROW()-2)*96+INT((COLUMN()-3)),MOD(COLUMN()-3,1))

but after 10 rows it starts to revert back to the first value.

I'm not sure the best way to do this.