How do I consolidate 2 tables into 1 pivot report?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Trying to consolidate pivot reports from two documents - they both have the
same sort of data in and headings.

Have managed to consolidate into 1 report however instead of showing the
headings in the pivot report it shows just Row and Column and lumps all the
data from different columns into the data area.
 
I just had this same question asked... Here's what I found:

Name the ranges you want to include in the different worksheets.

When starting the Pivot Table Wizard, (Data | PivotTable and PivotChart
Report), in the first step, select the radio button next to Multiple
consolidation ranges. Click Next. Choose either Create a single page for
me, or I will create the page fields. Click Next. On this step, you'll be
able to add your ranges. After clicking Next on this step, continue the
PivotTable Wizard as you normally would.

Hope this helps!
 
hi, just tried out your suggestion. This does consolidate the two ranges but
it doesn't give you a full field list - all you get is
row / column / value / Page

You can't really manipulate the report using just these headings - i wanted
to use the original coloumn titles (as in a normal pivot report).

any more ideas?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

pivot table 2
Consolidated Pivot table 1
Multiple Pivot Tables from Same data source 1
pivot tables 2
consolidate data in pivot table 1
pivot table multiple consolidation ranges 3
Consolidate tables/ranges with text from multiple worksheets 1
Using Pivot Table to consolidate multiple worksheets 1

Back
Top