Data manipulation

Hello all,

I am hoping someone will be able to help me with my data manipulation problem. I have a quarterly sales file that I am trying to use Alteryx to transform and automate. I will attach an example of the data that I receive below. I will be receiving this every quarter with the latest figures in them. Please see below for what I receive:

I would like to transform the data so that it is in the same format as the other data I use, so that it can be combined easily. Please see below for an example of how I want the data to look:

If anyone knows any techniques to do this via Alteryx I would really appreciate it.

Thanks!

Sales File.xlsx

Transformation

Accepted answers

joshuaburkhow

Hey @peterg97

This isn't the whole thing but wanted to get you something to start. You'll need to use the reporting tools to do the formatting into excel (which is totally possible). Hopefully this helps!

Pivot - Double Header Example.yxmd

All comments

joshuaburkhow

Hey @peterg97

This isn't the whole thing but wanted to get you something to start. You'll need to use the reporting tools to do the formatting into excel (which is totally possible). Hopefully this helps!

Pivot - Double Header Example.yxmd

peterg97

Hi @joshuaburkow,

Thanks for this! Solved my issue perfectly, really appreciate it!

Peter

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703