Extract data sheet from table

[Ogbergo]

Hi!

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:

Thanks!!

Best regards!

Stefan

[#2]

@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.

[#3]

@Riny_van_Eekelen Thanks! Worked like a charm!