Here below is a data table:

We want to convert the data to a 5-column & N-row table with header, in the order of horizontal arrangement first and then vertical arrangement. To achieve this, enter the formula in cell B2:

=spl("=?1.conj().group((#-1)\5)",A1:A26)

Subtract 1 from serial number # to get the difference, and divide the difference by 5 to get the quotient. Grouping by this quotient can put every 5 numbers in a group.
 

https://c.scudata.com/article/1651916536524
https://c.scudata.com/article/1656988651855
https://c.scudata.com/article/1657071273387