Transpose/Multiple Cross-Tabs?

[anncat]

I'm looking to either transpose or do multiple cross-tabs for the "Current dataset" below to the "Desired Result". My goal is to move the Year #, Quarter #, and Product Category so that they're going across the column headers instead of in one column each. 

Current Dataset

Product Category	Customer #	Vertical	Year #	Quarter #	Units
Series 1	Customer 1	Strategy	2018	3	5
Series 2	Customer 2	Cloud	2018	1	3
Series 1	Customer 3	Financial	2018	2	20
Series 3	Customer 4	Cloud	2018	3	1

Desired Result

Sum of Units		Year #	Quarter #	Product Category
		2018	2018	2018	2018
		1	2	3	3
Vertical	Customer #	Series 2	Series 1	Series 1	Series 3
Cloud	Customer 2	3
Cloud	Customer 4				1
Financial	Customer 3		20
Strategy	Customer 1			5

[jdunkerley79 · Accepted solution]

I think:

- Make a cross tab for each of the header rows

- Do a cross tab for the data

- Union in fixed order to build table

- Select tool to reorder and tidy up

[anncat]

Thank you very much! This was super helpful in learning how to use multiple cross-tabs!