How to transpose / convert a single column to multiple columns in Excel

preview_player
Показать описание
My Channel:
Рекомендации по теме
Комментарии
Автор

Awesome!
just what is the name of music?! (I really liked it...!)

aghilhassanzadeh
Автор

Thanks a lot! The other way round.

=OFFSET($A$1, (COLUMNS($A1:A1)-1)*6+(ROWS($1:1)-1), 0) English version

German version

zcq
Автор

please help on this formula, , , , it will b a great help...thank you

kalkun
Автор

very useful but you should explain in detail, It took more time to understand it...
Formula Detail =OFFSET($A$1, (COLUMNS($A1:A1)-1)+(ROWS($1:1)-1)*6, 0)

sonukumar-jxnw