I am not an expert in Pivot Tables. I used to use them years ago, but now it's all Greek to me.
Anyway, I started clicking on various drop down boxes and select5ing things and finally I got what I wanted. Not exactly in the format I want, but at least it is in Excel and I can manipulate it to look like I want.
I can't understand why Microsoft hasn't made it an easier process. Heck, even I could probably attempt to write a macro linked to a button that would do this.
Thanks again, you're the best

You're welcome for the assist. If you want to manipulate the data outside of pivot table, you can convert the pivot table to formulas. That may be a bit easier for presentation purposes - but you'll remove the ability to pivot the data.