Pivot Tables

Garrett_Turner 

Here are two ways:

1. Add new tab, select insert pivot table, and select the range B1:F166.  Then build your pivot table.

2. Export the data to Power Query.  To do this, you have to change the range of table1 down to row 166.  Then under data, select "from table/range" in the "get and transform data".  This open PQ-there's lots of formatting you could do.  I only filled down on A and B, then filtered to only your "total" row.  Then close to insert a pivot table.  

Hope this helps.