Transform data

[ulrich_schumann]

Hi *,

we receive on a regular basis an Excel file that I need to restructure in order to further process the data. I have tried with the transpose tool, but got problems with the given structure.

Year is given in a combined cell only once per value. Quarter might be sightly different written per year. The enclosed Excel shows in the "source" tab an example of the data and in the "target" tab the desired solution. Any suggestion how to get this transformed?

Thanks,

[afv2688 · Accepted solution]

Hi @ulrich_schumann 

I think this will do it

Cheers

[davidrioux · Accepted solution]

Hello: Another possible solution you can also check out.

[gantaanvesh]

Hi, can someone help me with transformation, am facing challenges to bring desired output.

[ulrich_schumann]

Hi @gantaanvesh ,

it is very helpful to upload sample data so that people can work on a solution. From my experience, without data is is unlikely to get an answer.

[gantaanvesh]

Hi pfa sample data