Select the cells you want to create the PivotTable from
Select Insert>Pivot Table
3. Once you click this, it will create a PivotTable based on an existing table or range
4. Choose the location of PivotTable report to be placed. Select NewWorksheet to have the PivotTable be created in a new worksheet or Existing Worksheet and select the location you want it to appear.
5. Select OK.
6. All done!
Table Originals team