You should be able to make the pivot table.
It should summarize the data to return less than the 80,000 rows, if you set the fields as you want them.
If you have problems then why not create a query in Access to summarize the data and then import that into Excel.
In fact you could create a crosstab quesry in Access which is the equivalent to a pivot table.