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 | |
