Forum Discussion
Stacking row/columns of an array - some module formulas
I just wrote a few functions that should theoretically allow you to take an array, chunk it by rows or columns, and then stack them in the other dimensions, e.g. you have 10 rows by 3 columns and you...
For users needing to reshape and manipulate data without creating custom functions, leveraging Power Query can be powerful. It has built-in functions for pivoting, unpivoting, and transforming data much like what you described.