Excel Pivot Table with multiple rows and columns

[all-tricks-rick]

Is there a way to have a sum/count/grouping as the "values for new columns" within the Cross Tab tool? Say for this example my data looked like this: 

I want Asset and Liability to become headers (like phone number 1 and phone number 2) and then I want to sum the Market Values grouped by Classification and count the number of Record IDs grouped by Classification. Can I do this using a combination of this cross tab tool and a summarize tool? Ideally I would want it to look like the pivot table in excel below.

[robdelisle · Accepted solution]

I believe this will give you what you want. It sounds like you know how the crosstab and summary tools work just weren't able to figure out the combination. Let me know if you have any questions though and I can explain what's going on or if you need something different.

-Robert

[all-tricks-rick]

That worked! Thank you!

[okakosolikos]

I'm really happy and also very sad and frustrated that I had to waste 2 hours searching to find the solution.
It's literally 4 drag 'n' drops in excel, why can't a pivot tool exist in alteryx?

It's been almost 2 years from the posted solution and no pivot tool.

I'm hopping off to waste another 30 minutes to implement this to my own workflow and I'm afraid I have to bookmark this one..

Thanks Robert