Complex cross tab to arrange data

[503Phil]

Hello Community!

I hope everyone is having a good week.  I'm fairly new to Alteryx and trying to figure out the best way to do what appears to be a complex data arrangement (Hoping this is just me!).  This is needed to meet a specific script template and isn't flexible.  I've played around for a few hours and I'm stuck.

Here's a screenshot of what I'm trying to accomplish:

Data, Country and Product being my primary fields but cannot for the life of me figure out how to get all of the sizes and quantities collapsed to one row.

Any pointers or advice would be appreciated!

Thank you!

[DavidP · Accepted solution]

If you use a Tile tool you can split the data and crosstab Size and Quantity separately, then join them together again. Only problem is that you have to manually arrange the size and quantity columns in the join tool to get them in the right order.

[503Phil]

Thank you David!  This worked out great and produced the exact results I was looking for.