1. Open your Excel spreadsheet, select the cells you want to create a PivotTable from.
Note: Your data shouldn't have any empty rows or columns. It must have only a single-row heading.
2. Select Insert > PivotTable.
3. Under Choose the data that you want to analyze, select Select a table or range.
4. In Table/Range, verify the cell range.
5. Under Choose where you want the PivotTable report to be placed, select New worksheet to place the PivotTable in a new worksheet or Existing worksheet and then select the location you want the PivotTable to appear.
6. Select OK.