Forum Discussion
unpivot data and handle merged cells without using Power Query (Unpivot_Toolkit)
Hey, guys!! I’ve been working on a set of functional Excel Lambdas to solve a common headache: transforming "Wide" human-readable data into "Long" database formats without having to open Power Query...
Looks impressive!
A useful step towards providing new calculation options.
- My first choice might be to use array formulas directly on the data objects held within your crosstab
- The next might be to use your 'souped up' unpivot followed by database-style aggregations
- Repivot to form a new crosstab with the restructured arrays for calculation
Choice is good.