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

A

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
 
M

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?
 
A

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top