Transpose a row of data and keep posting that info down

[FVFO]

Hi,

Hope someone can help with this:



Just wondering if this can be achieved via formula or will a VBA macro be necessary to achieve such a feat.

Hope someone can help!!

 

[Haz]

Check the attached file.

 

[bosco_yip]

1] Assume your data in A1:E1

2] In G1 copied down :

=INDEX($A$1:$E$1,AGGREGATE(15,6,COLUMN($A$1:$E$1)/($A$1:$E$1<>""),MOD(ROW(A1)-1,COUNTA($A$1:$E$1))+1))

Regards
Bosco