Create a pitvot table with from several tables that have identical columns?

[OldManExcellor]

I have six tables that have identical columns.

The columns are:

Product code, Sales, Counctry, Currency and so on...

I know how I can create a pivot table for each individual table. But is it possible to create a pivot table with rows from all the tables?

[Kyle123]

In the pivot table wizard, choose the option to create from "Multiple consolidation ranges", though I suspect these should all really be a single table

[Richard Buttrey]

Hi,

I agree with Kyle. Create a single table. If your six tables each mean something different, just add an extra column to your single database and enter in there for each record a reference to the meaning of the current tables. e.g. the new column would contain text like 'Table1', Table2...Table6'

[OldManExcellor]

I understand what you are saying, that they should be all one table. But in this case, for various reasons it was decided to have different tables.

When I use the pivot table wizard to consolidate I don't get the pivot table fields I am used to getting. I only get Row, Column and Value. I don't get Product code, Turnover and those kinds of fields (which are columns in my tables). Do you have any idea what I might be doing wrong?

For each range I am adding, I am choosing all columns, the headers of the tables and then all rows of the tables.

SNAG-0000.png
SNAG-0001.png
SNAG-0003.png

[Richard Buttrey]

I understand what you are saying, that they should be all one table. But in this case, for various reasons it was decided to have different tables.

Why? For what benefit?

If the data is perhaps imported from an external source I'd still be inclined to have a pre-processing macro that consolidates the tables into a single table and use a single PT.

[Kyle123]

Please post a sample workbook