Multi-range Pivot Table with "real" field buttons

speed23

New Member
Joined
Sep 26, 2002
Messages
1
I have two large, static files identically laid out that must be combined into a pivot table. I've tried the multi-range selection in the wizard, but the result gives "dummy" field buttons (such as Row, Column, Page, Data) rather than the "real" field buttons (ie., the column headers). How to create a pivot table with all this data using the real field buttons?? Thanks very much in advance.
 

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

Mark W.

MrExcel MVP
Joined
Feb 10, 2002
Messages
11,654
The option in question is labelled "Multiple consolidation ranges". To use this option your data should conform to that used for worksheet Consolidations. See the Excel Help topic, "Consolidate data by category", for a thorough understanding of this concept.
This message was edited by Mark W. on 2002-09-28 09:49
 

Forum statistics

Threads
1,144,210
Messages
5,723,050
Members
422,476
Latest member
beck85

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top