How do I create a pivot table to consolidate multiple data ranges?
A pivot table is an interactive spreadsheet tool in Microsoft Excel that summarizes multiple data ranges in a single condensed, easy-to-read format for a simpler method of data reporting and analysis. Use it to arrange, count and total your data as you add different fields and create cross tabs. Some pivot table programs allow you to shuffle, hide or display certain categories to show several different relationships between the data.Create a Pivot TableIn the Microsoft Excel spreadsheet workbook, click a blank cell that is not a part of the pivot table. Press “ALT+D+P” to begin the Pivot Chart Wizard. Select “Multiple Consolidation Ranges” and then click “Next.” Select whether you will use a pivot table without page ranges, a pivot table with a single page field or a pivot table with multiple page fields depending on how many spreadsheets you want to consolidate. For a single page field, click “Create a Single Page Field For Me” on Step 2a of the Pivot Table Wizard and then click “Next
