When Microsoft first included Pivot Tables in Microsoft Excel (early 1990’s as I recall), it took me a little bit of time to get my head around what they were and what they were good for. Once in head, I recognised how powerful they are.
The next step was to be able to do “reverse Pivot Tables” on data presented in summary Pivot Table format. That seemed impossible without doing coding in VBA or something.
This web site explains how to do it from with Excel without coding. First time I ever saw this. Perhaps this capabilty included in Excel when Pivot Tables entered into Excel. I don’t know. But this is good stuff.