December 1, 2022
July 16, 2010
Welcome to our forum! Thanks for sharing your file. The structure of the data is not suitable for PivotTables. It should be in a tabular layout. This video on PivotTables will illustrate the problem you have with your data in that format.
You can use Power Query to unpivot the data.
I hope that points you in the right direction.