Pivot Table - Multiple consolidation Range
 

I am trying to use the Pivot Table wizard to consolidate multiple columns of
data.
The data is in one Excel file.
In the Excel file the columns are laid out in the order I wish it to be laid
out in the Pivot Table Report.
When the Pivot Table is prepared the columns are in Alphabetical order in
the Pivot Table Report.
i.e:
Co 1 is "Sales"; Col 2 is "Advertising"; Col 3 is "Purchases"; Col 4 is "Net
Margin"
(This is the order I want to report in the Pivot Table)
When the Pivot Table is run the columns are in the following order:
Co 1 is "Advertising"; Col 2 is "Net Margin"; Col 3 is "Purchases"; Col 4 is
"Sales"
The only thing I know to do is to label the columns in the excel file in
numerical order and copy the Column Names to the Pivot table report after it
has been prepared.
I know there is an easier way???

You can manually reorder the columns after the pivot table has been
created. Right-click on one of the pivot table column headings, and
choose OrderMove Left (or one of the other options).

tengreen wrote:
I am trying to use the Pivot Table wizard to consolidate multiple columns of
data.
The data is in one Excel file.
In the Excel file the columns are laid out in the order I wish it to be laid
out in the Pivot Table Report.
When the Pivot Table is prepared the columns are in Alphabetical order in
the Pivot Table Report.
i.e:
Co 1 is "Sales"; Col 2 is "Advertising"; Col 3 is "Purchases"; Col 4 is "Net
Margin"
(This is the order I want to report in the Pivot Table)
When the Pivot Table is run the columns are in the following order:
Co 1 is "Advertising"; Col 2 is "Net Margin"; Col 3 is "Purchases"; Col 4 is
"Sales"
The only thing I know to do is to label the columns in the excel file in
numerical order and copy the Column Names to the Pivot table report after it
has been prepared.
I know there is an easier way???


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html