How to Create a Pivot Table to Consolidate Multiple Data Ranges
With the Microsoft Excel spreadsheet application you can create a PivotTable report to summarize and evaluate the data you have added to your worksheet. When you create a PivotTable for the first time you can choose to consolidate your data in order to combine multiple data ranges. Before you start to create your PivotTable you will need to make sure that you have all of your data set up. You can also open more than one workbook to select multiple data ranges and select the worksheet where you want you PivotTable to be inserted.
Other People Are Reading
Instructions
-
-
1
Open the Microsoft Excel application that contains that data you want to create a PivotTable for on your computer. Click on any blank cell within your worksheet.
-
2
Click on the "Data" option and then click the "PivotTable and PivotChart Report" option for Excel 2003. Press the "ALT", "D" and "P" keys at the same time for Excel 2007. The PivotTable and PivotChart Wizard will then appear.
-
-
3
Click on the "Multiple consolidation ranges" option and then click on the "Next" button. Click on the "I will create the page fields" option and then click on the "Next" button.
-
4
Click on the "Collapse Dialog" option and then select the first data range you want to add from your worksheet. Click on the "Add" button to add the data range.
-
5
Click on the "Collapse Dialog" option again to select another data range that you want to add. Click on the "Add" button again to select your second data range. You can then continue to add as many data ranges as you want.
-
6
Click on the "0" option below the "How many page fields do you want?" field and then click on the "Next" button. Select a location for your PivotTable to be placed in your worksheet and click on the "Finish" button.
-
1
