What is the difference between a vision statement and a mission statement? What is the difference between sight and vision? What is the difference between a dream and a vision?
1 If the column you want represented in your pivot table does not already exist in the source data worksheet, you will need to insert a column by right clicking on an existing column and choosing Insert Column from the popup menu.  If you added a column to your source data, populate that column with the relevant data.
Building the Pivot Table. 1  1. Load the spreadsheet you want to create the Pivot Table from. A Pivot Table allows you to create visual reports of the data from a spreadsheet. 2  2. Ensure that your data meets the needs of a pivot table. A pivot table is not always the answer you are looking for. 3  3. Start the Pivot Table wizard. Click the Insert tab at the top of the Excel window. Click the PivotTable button on the left side of the Insert ribbon. If you are using Excel 2003 or earlier, click the Data menu and select PivotTable and PivotChart Report...