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/