Reverse transpose

[legwu]

Hi Alteryx Community,

I have a problem with a dataset. I need to create a table with multiple fields, changing some of the data values to fields, when I have received data with only two fields. It is sort of a 'reverse transpose'.

This isn't very clear an explanation, I apologise, but I have added a spreadsheet to illustrate the transformation I am looking to do on the data set.

The 'Before' tab shows the data format currently. The 'After' tab has the desired result.

I am struggling to find the combination of operations to do this. One option is a formula which performs a look up in the data set for each field (i.e. a formula for a field 'State' which looks up the 'Company' field and 'State' to find the answer). But I'm not sure how to code this sort of multi-field vlookup either. Can you help with this?

Thanks,

Lincoln

[jacob_kahn · Accepted solution]

@legwu 

No problem! I think you can get this done with one tool, called the Cross Tab tool!

Let me know if this helps.

Please like and accept if it does.

Thanks, 

J

[legwu]

Thanks for this! This has worked perfectly.