Select any cell in your data range
Make sure your data has column headers
Go to the Insert tab
Click PivotTable
Confirm the table or range
Choose where to place the PivotTable
Click OK
In the PivotTable Fields pane, drag fields to Rows, Columns, Values, and Filters
Adjust the layout and summarize data as needed