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,

Transformation

Accepted answers

Hi @ulrich_schumann

I think this will do it

Cheers

Hello: Another possible solution you can also check out.

All comments

Hi @ulrich_schumann

I think this will do it

Cheers

Hello: Another possible solution you can also check out.

Hi, can someone help me with transformation, am facing challenges to bring desired output. Screenshot (56).png

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15865

MarqueeCrew 13708

apathetichell 13703