Multi Range Pivot Table

Multi Range Pivot Table in Excel SpreadsheetThe Pivot table is a powerful and extremely useful tool to prepare a consolidation of data. This is particularly useful where some or all of the row headings are repeated and need to be totalled. But if there is more than one range or table of source data which needs to be consolidated, how do we go about doing that? The answer lies in constructing a ‘Multi Range Pivot Table’.

The purpose of our spreadsheet Multi Range Pivot Table is to consolidate several ranges or tables. This is where the column headings are the same but the row headings may well be different. The pivot table in the example spreadsheet consolidates into one, two tables on one sheet and two tables on a second sheet.

The editable version of this worksheet is without restrictions and passwords, allowing you to freely view and change the code etc, to meet your own requirements. Price will be subject to the current rate of UK VAT where applicable.

We recommend that you add our email address ( to the contacts in your email program to help prevent our emails from going into the spam/junk mail folder.


We do require your email address in order to send the link to your free worksheet, and it would be good to use your name in a personal thank you. Our privacy policy is your assurance that any personal information is safe with us.