Select your data range
Make sure your data has headers
Click the Insert tab
Click PivotTable
Choose the table or range
Select where to place the PivotTable
Click OK
In the PivotTable Fields pane, drag fields to Rows, Columns, Values, and Filters
Adjust value settings if needed
Format the PivotTable as desired
