'Turning single column data into a grid

I have this data:

enter image description here

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