Extract data sheet from table

New Contributor



I would like to convert the following table to a datasheet which puts the different dimensions in separat columns. Is this possible? I was trying to concatenate and the split them up, but ended up with a lot of manual rows and a not so simple solution.

The table looks like this (small piece of the total table):



And I would like to end up with the following:





Best regards!





2 Replies

@Ogbergo If you are on a PC you can use Power Query (known as Get & Transform Data" on newer versions) to unpivot the data. An example is attached.


@Riny_van_Eekelen Thanks! Worked like a charm!