Design a PivotTable

1. Choose your preferred cells to create a PivotTable from: Note:  Your data shouldn’t contain any blank rows/columns. It must only include a single-row heading.  
2. Click Insert > PivotTable.  
3. Below Choose the data that you want to analyse, choose Select a table or range.  
4. In Table/Range, confirm the cell range.
5. Under Choose where you want the PivotTable report to be placed, select New worksheet to arrange the PivotTable in a new worksheet or Existing worksheet and then confirm the location you want the PivotTable to be based.
6. Press OK.

Structuring the Contents of your PivotTable

1. To insert a field in your PivotTable, confirm the field name checkbox in the PivotTables Fields pane. Note: Chosen fields are placed in their pre-defined sections: non-numeric fields are set to Rows, date and time hierarchies are allocated to Columns, and numeric fields are inserted into Values.  
2. To relocate a field from one field to a different one, drag the field to the desired area.