Dynamic Array Formula to Unstack data in Excel

preview_player
Показать описание
In this video, I am explaining an Excel formula that can be used to unstack data from a column to different columns.

🍐Join my online course on Excel Tables

🍓Download my free eBook on Excel Macros

🍇Check these Books on Excel

🍉Read my articles on Excel

🍏Playlist for Shorts on Excel

#excel #exceltip #exceltrick
Рекомендации по теме
Комментарии
Автор

Great stuff. It’s great to see how different solutions work

I’ll try making STACK and UNSTACK functions using LAMBDA I’ll allow the user to stack or unstack by row (like what you did) or by column

patrickschardt
Автор

Great video!! to get rid of errors and extra area out of reference:
=INDEX(B3:B22, SEQUENCE(COUNTA(B3:B22)/COUNTA(D2:G2), COUNTA(D2:G2))) or
=LET(a, B3:B22, c, 4, r, COUNTA(a)/c, INDEX(a, SEQUENCE(r, c))) where a is the array and c, the width to unstack to.

Excelambda
Автор

I am simply amused!!!

If you add project file at description then it Will be butter and bread.

MaMuNAcademY
Автор

hi ajay how can i make a list of files and folders using array ??

anmac
welcome to shbcf.ru