Steps

1. Select the complete dataset.
2. Go to Insert → PivotTable.
3. Select the data/table.
4. Choose New Worksheet.
5. Click OK.
6. The PivotTable Fields pane appears.
7. Drag fields into:
   • Rows
   • Columns
   • Values
   • Filters

Example

For a sales report:

Rows: Product
Values: Sales

Result: