Hi,
I’ve got data structured like this:
and I’d like to get as a final table something like that:
Test Unpivot.xlsx (49.7 KB)
Any idea?
Thanks in advance
Michel
Solve partially using label column first and split after…
But not so easy in real life to use the split because of spaces inside labels…
Hi Michel,
if column labels need to be concatenated using a separator, they can be aggregated in the Concatenate mode in a separate table.
See the project below:
unpivot-multiline-header.morph (5.0 KB)
Hi Dmitry,
Very clever and elegant solution!!! Bravo!!!
You’re welcome!