Hi, I need a pivot table that combines 4 quarters of information. I tried using the pivot table wizard to consolidate ranges but it did not seem to work as one range differs from the others.

I need the pivot table to first split FM and SM
Then under each of those I need it to count how many PGY1, PGY2, PGY3, PGY4, and PGY5 in each quarter
Then I need it to calculate the total sum of training months for each PGY level.

I have attached the spreadsheet with all the information, as well as on sheet 1 I made what the pivot table is supposed to look like, but it only includes quarter 1.
As soon as I enter Quarter 2, 3, and 4 info, it doesnt seem to be counting the data properly and also makes the report look sloppy.

I want it to look just as is on sheet 1 but with all 4 quarters included.

Training Quarters.xlsx