Select your data range
Go to 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
Use the field layout to arrange the data as needed
Adjust value settings if necessary
Refresh the PivotTable when the source data changes