This .. or do you know anyone who can run a Sql query? Do you have any databases at work (access, SQL servers?) that collect/store transaction data?
I guess I'm asking how do you store your data? Because all that information is in there, already formatted to convert to a pivot table and organize exactly how you're describing. Once you figure out how to manipulate/organize the data, it's pretty damn easy and quick.
If you don't or don't know, then you're in for a lot of data inputting which is fucking tedious .. best hire an intern for that shit.