Thank you both!
I did rearrange the data, although not what the staff enter. They are _not_ tech savvy, so since they do this correctly, I wanted to keep it familiar.

I love that Excel can let me put the same data in a different cell, and that is what I did.

And the pivot table tutorials are amazing! I had a very crude knowledge of how they worked, but this has opened up several things that I want to do with other data that I have!

I have not completely got it figured out, but I am very close to getting the data in a format that will actually be helpful!
Thank you all so much!
Ray