Multi Row Header Cross Tab?

[cjaneczko]

I have data that I am trying to pivot and report out two or more headers of data. The headers would be Customer/Year/Month

Customer	Part Number	QTY	Month	Year
A	123	100	1	2022
A	456	200	2	2022
B	123	250	1	2022
B	789	150	2	2022
C	123	50	1	2022
C	678	75	3	2022

Id like it to look like:

	A	A	A	B	B	B	C	C	C
	2022	2022	2022	2022	2022	2022	2022	2022	2022
	1	2	3	1	2	3	1	2	3
123	100	0	0	250	0	0	50	0	0
456	0	200	0	0	0	0	0	0	0
678	0	0	0	0	0	0	0	0	75
789	0	0	0	0	150	0	0	0	0