Unpivot with many Title Lines

I’ve got data structured like this:
and I’d like to get as a final table something like that:
image Test Unpivot.xlsx (49.7 KB)
Any idea?
Thanks in advance

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!