Transpose Multiple Columns into a Single Row

5 columns would be
=INDEX(A:E,CEILING(ROWS($A$1:A1)/5,1),MOD(ROWS($A$1:A1)-1,5)+1)
6 columns
=INDEX(A:F,CEILING(ROWS($A$1:A1)/6,1),MOD(ROWS($A$1:A1)-1,6)+1)
7 columns say G:M

=INDEX(G:M,CEILING(ROWS($A$1:A1)/7,1),MOD(ROWS($A$1:A1)-1,7)+1)
and so on