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:
Solved! Go to Solution.
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).
It has now been linked
Here is how you can do it. The above branch handles headers and the below branch handles data.
Workflow:
Hope this helps : )