Organize the source data in a tabular format with clear column headers
Remove blank rows and blank columns from the data range
Ensure each column contains one type of data only
Select any cell within the data range
Insert a pivot table from the Insert menu or PivotTable option
Confirm the data range and choose where to place the pivot table
Click OK or Create
Drag fields into Rows, Columns, Values, and Filters areas
Choose the summary calculation for value fields if needed
Format the pivot table for readability
Refresh the pivot table when the source data changes