Looking for a way to summarize data?
 

I have payroll data reports emailed to me every week from our time and
attendance system (Kronos) in excel format. The data is not in a database
format ie: there are blank columns and rows.

I'm looking for a way to summarize the data. There are columns and row
labels, but I don't think I can use a pivot table because the report is not
in database format. I'm looking for suggestions.