Excel and Power BI Stacking Grouped Columns Challenge

The team and I at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World. https://accessanalytic.com.au/

👏🏻 Update - thanks to @ianrhile for suggesting a simpler approach avoiding GroupBy and utilising INTEGER DIVIDE. I've added that method to the demo file below

Demo File
https://aasolutions.sharepoint.com/:f...


Submit alternative solutions to [email protected]


A super simple DYNAMIC ARRAY formula such as
=WRAPROWS(TOCOL(Table1,1),3) could solve this solution if it was a one off Excel only solution



Did you know I've written a book "Power BI for the Excel Analyst"?
https://pbi.guide/book/


Connect with me
https://wyn.bio.link/