how to use an formula to transpose a list(left) to be like the right?

[Alex]

a1 a1 a6 a11 a16
a2 a2 a7 a12 a17
a3 a3 a8 a13 a18
a4 a4 a9 a14 a19
a5 a5 a10 a15 a20
a6
a7
a8
a9
a10
a11
a12
a13
a14
a15
a16
a17
a18
a19
a20

 

[Max]

Source data assumed running in A1 down
In B1: =OFFSET($A$1,COLUMNS($A:A)*5-5+ROWS($1:1)-1,)
Copy down to B5, fill across as far as required

Q: how to use an formula to transpose a list(left) to be like the
right?

 

[Alex]

Source data assumed running in A1 down
In B1: =OFFSET($A$1,COLUMNS($A:A)*5-5+ROWS($1:1)-1,)
Copy down to B5, fill across as far as required

Q: how to use an formula to transpose a list(left) to be like the
right?




- Show quoted text -

Many thanks. Max.