Transpose Multiple Columns into a Single Row

how many exactly is that a true representation of your data?

Something like this?

for 4 columns
=INDEX(A:D,CEILING(ROWS($A$1:A1)/4,1),MOD(ROWS($A$1:A1)-1,4)+1)

although the suggestion by popipipo works there is an error in the first 4 rows
=INDEX($A$1:$D$53,INT((ROW()-0.5)/7)+1,ROW()-INT((ROW()-0.5)/7)*7)
should be
=INDEX($A$1:$D$53,INT((ROW()-0.5)/4)+1,ROW()-INT((ROW()-0.5)/4)*4)

I saw that later.
Row 1 to 4 I forgot to correct it, but from row 5 it is ok

Originally Posted by martindwilson

how many exactly is that a true representation of your data?

Sorry; I should have clarified further. The example I included is representative insofar as there are indeed 4 rows of data. The ideal solution, however, could be used for any number of columns. Popipipo, I have had success with your approach. Thanks very much the same to everyone else who contributed!

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