Feb 03 2021 11:15 PM
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
Feb 04 2021 01:13 AM
@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.
Feb 04 2021 04:30 AM
@Riny_van_Eekelen Thanks! Worked like a charm!