I definitely make these are much harder than they are in my head. I can say that I knew i had to do a transpose & cross tab but couldn't figure out how to properly execute it. I took a look at a few other solutions to see if I was on the right track and I was! I did figure out early on with Google to use Select Records tool prior to looking at other solutions...so I'll pat myself on the back for that lol.
My solution is below