Creating a Pivot Table in Excel

1.

1. Select all the data in your spreadsheet, including the headers.
2. Go to the Insert tab in the ribbon at the top of the screen.
3. Click on PivotTable in the Tables section.
4. In the Create PivotTable dialog box, make sure the range of your data is correct and choose where you want to place the pivot table (either in a new worksheet or in an existing one).
5. Click OK.
6. You should now see a blank pivot table and a PivotTable Fields pane on the right side of the screen.
7. Drag the Origin State field to the Rows area in the PivotTable Fields pane.
8. Drag the Dest State field to the Columns area in the PivotTable Fields pane.
9. Drag the Company field to the Values area in the PivotTable Fields pane.
10. You should now see a matrix with all the states/provinces in the rows and columns, and the cells populated with the company names.

You can customize the pivot table further by adding filters, changing the calculation type, and formatting the table to your liking.