After the long Excel Video 20, here’s a short video to show how flexible the consolidation process is. I simply take the same data that we used before, where all three ranges had exactly the same Profit and Loss categories, and changed one of the categories in one of the locations from Utilities to Depreciation. After refreshing the data, Excel shows both Utilities and Depreciation as expenses, leaving blank cells for divisions without that expense. It’s a good demonstration that your ranges don’t have to be absolutely exact for Excel to consolidate the data into a Pivot Table.
This has been a long series of examples of consolidating multiple ranges. Excel 2007 moved it off the ribbon, so you can surmise that it’s not the most popular Pivot Table feature, but when you need it, now you know where to find the wizard and how to use it.