'Turning single column data into a grid
I have this data:
The grid of blue cells are created by using these formulas manually in column C:
C1: TRANSPOSE(A1:A5)
C2: TRANSPOSE(A6:A10)
C3: TRANSPOSE(A11:A15)
C4: TRANSPOSE(A16:A20)
C5: TRANSPOSE(A21:A25)
C6: TRANSPOSE(A26:A30)
I'm trying to create one formula using Arrayformula in C1 that will automatically create the blue grid with N columns - currently N being 5.
Tried multiple ways to generate the range to transpose but not getting anywhere.
Any pointers on how to go about this?
Note: This could be done using app script, but I do not want to go that route and stick with Arrayformula or whatever that works.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|

