Cross Tab with Multiple Column Headers

[twheeler]

I am fairly new to Alteryx, and I am trying to take a data set that looks like the below:

Acount	Acct Desc	Legal Entity	LE Desc	Amount
60000000	Sales	ABC001	ABC Company	50000
60001000	Sales - Other	ABC001	ABC Company	30100
60000000	Sales	ABC005	ABC Limited	75000
60001000	Sales - Other	ABC005	ABC Limited	25250

And change it to look like the following:

		ABC001	ABC005
Acount	Acct Desc	ABC Company	ABC Limited
60000000	Sales	50000	75000
60001000	Sales - Other	30100	25250

I can use the cross-tab tool to get either Legal Entity or LE Description as the column header, but how do I get two columns, as shown?  Any help would be greatly appreciated.

[twheeler]

Hi Jim - I have attempted to run this with my entire data set now, and it appears to working great for the most part.  The only issue is that at the end, I still have some alignment issues with some of the entity codes showing over the acct description.  I can't understand why.  When I export each of the tables before the join, it looks like they are doing what they should be doing.  It is like the Join isn't joining by position.

Table 1:

Table 2:

Final Browse Tool:

[ibvelaine]

Hi @Jim7  Would you be able to share a sample workflow that's compatible with Alteryx version 11 please?

I tried opening the workflow file you provided but i wasn't able to open it because my Alteryx has an older version :(