Transforming data with multiple transpose dimensions.

[sebastian123Han]

Hey! I have a problem with a dataset that needs to be transformed.

I have attached the data. Basically what I want to do, is having the column headers for (Center, Period ( with values months and year), Type, KPI (basically the column that already exist) and Value).

I have tried a lot of different solution, first assigning record ID transposing and so, but I find it extremely difficult getting to correct structure of the new dataset.

Can anybody help here? The excel linked is how I wish the data to come out:

[Emil_Kos]

Hi @sebastian123Han,

The expected outcome is always beneficial.

It would be even better if you would provide an excel file with the expected output(in case someone want to validate their work). 

[sebastian123Han]

It has now been linked

[atcodedog05 · Accepted solution]

Hi @sebastian123Han 

Here is how you can do it. The above branch handles headers and the below branch handles data.

Workflow:

Hope this helps : )