We've built the goldmine. Now we need to mine it — find what's hidden inside through sorting and aggregating.
That's exactly what pivot tables are designed for. A pivot table creates a new calculation sheet inside this workbook.
Since we're adding something new, go to the Insert tab. Click the PivotTable button — not the dropdown arrow below it, the button itself.
The source data is the left table. You only need to click one cell inside it — Excel will recognize the entire table as the source