How To Make A Pivot Table?

Select your data range

Make sure your data has headers

Click the Insert tab

Select PivotTable

Choose the table or range

Choose where to place the PivotTable

Click OK

Drag fields into Rows, Columns, Values, and Filters

Adjust value settings if needed

Format the PivotTable if desired