Forum Discussion
Unpivot Monthly Data with a Formula
Note: I know how to unpivot data using PowerQuery and vba. What I'm interested in with this exercise is using a formula to unpivot monthly data. I'm interested in using some of the newest functions...
Both solutions are excellent considering the constraints. MAKEARRAY's drawback seems to be that it needs the help of INDEX unless you're using it to create random data. It's a bit easier to use HSTACK/VSTACK where needed. Stacking seems to be the Excel Team's answer to the array of arrays limitation.