Extract data sheet from table

New Contributor

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):

Ogbergo_0-1612366483364.png

 

And I would like to end up with the following:

Ogbergo_1-1612366501728.png

 

Thanks!!

 

Best regards!

Stefan

 

 

 

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!