how to make a pivot table

To create a pivot table, select any cell in your data, go to the Insert tab, click PivotTable, and then drag fields into the Rows, Columns, and Values areas to summarize your information.

Prepare your source data. Before starting, ensure your data has unique column headers, no blank rows or columns, and no merged cells. Converting your data range into an official Excel table (Ctrl+T) helps the pivot table automatically include new data as you add it.
Insert the pivot table. Click any cell within your data set, navigate to the Insert tab on the ribbon, and select PivotTable. In the dialog box that appears, confirm your data range and choose to place the pivot table in a new or existing worksheet.
Configure your report fields. Use the PivotTable Fields pane to organize your report. Drag fields to Rows to create labels down the left, Columns to create categories across the top, and Values to perform calculations like sums or counts.
Verify your results. Always verify your results by comparing the pivot table's Grand Total to the total of your original source column. If they do not match, your pivot table may be reading an incorrect range or missing data due to gaps.