How to transform this data

[AmitBelagali]

Hi All,

We have a scenario wherein we have few rows that needs to be transformed as columns. Please find attached screenshot. In this, we have Region, Sector, Filter, Metric Filter, Population and Brand as rows and below that we have data as column. We need to make all these as columns with date. 

Also, like this we have around 10-12 sheets with same structure. 

Could you please help us on this?

I have attached both input and output file screenshot.

Thanks,

Amit Belagali

[AmitBelagali]

Hi @LordNeilLord,

Thanks a lot for your help. We cracked all the further steps by using your workflow. You are a rockstar. 

Thanks a lot again.

Thanks,

Amit Belagali

[MarqueeCrew]

@AmitBelagali

I second your nomination of @LordNeilLord to rockstar status. I also think that kudos are in order for your contribution to the community with a post asking for assistance as well as your recognition for Neil's help. 

Cheers,

Mark

[LordNeilLord]

If only more people like @AmitBelagali were brave enough to ask for help :)