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

[LordNeilLord]

hey @AmitBelagali

There are no screens attached.

But have you looked into the crosstab tool?

[AmitBelagali]

Hi @LordNeilLord,

Tried that Neil. But in vain. Could you please suggest us a different way?

[LordNeilLord]

Ewww, that looks like one messy spreadsheet!

Without an actual example of the data it's going to be hard to give you a full solution...but looking at it from the pics...this is probably going to need some muli-row formula tools and a few transposes first.

Can you attach an example of the actual data (or that mock up you just screen shotted)?

[AmitBelagali]

Hi @LordNeilLord,

Please find attached mockup data.

Thanks for your help.

Thanks,

Amit Belagali

[LordNeilLord]

Hey @AmitBelagali

Have you tried to import your mockup into Alteryx?

I can only get to import the first 8 rows

[AmitBelagali]

Hi @LordNeilLord,

I have tried loading the file. The file loads fine. In the Preview only first 8 rows are loaded don't know the reason why. But i am able to load the file.

Thanks,

Amit Belagali

[LordNeilLord]

Hey, yeah I got it loaded

[AmitBelagali]

Awesome. Could you please me with further steps?

[LordNeilLord · Accepted solution]

Hey @AmitBelagali

Sorry for the delay

I've attached an example of how to approach one of the sections, mostly reliant on Multi-Row formula. Use this to get you started and see if you can figure out the rest :)