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