Can you spread Pivot Table "Value" Fields in seperate columns
 

When multiple feilds are placed in the Values window of the pivot table setup
screen, the resulting data is stacked in one column. Can this data be spread
into seperate columns?

Can you spread Pivot Table "Value" Fields in seperate columns
 

Try dragging that "Data" field and drop it over "Total" - this should
rearrange it into the columns format that you seek.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:365 Subscribers:65
xdemechanik
---
"rsnow" wrote:
When multiple feilds are placed in the Values window of the pivot table setup
screen, the resulting data is stacked in one column. Can this data be spread
into seperate columns?

Can you spread Pivot Table "Value" Fields in seperate columns
 

This did not seem to work in Excel 2007

"Max" wrote:

Try dragging that "Data" field and drop it over "Total" - this should
rearrange it into the columns format that you seek.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:365 Subscribers:65
xdemechanik
---
"rsnow" wrote:
When multiple feilds are placed in the Values window of the pivot table setup
screen, the resulting data is stacked in one column. Can this data be spread
into seperate columns?

Can you spread Pivot Table "Value" Fields in seperate columns
 

This did not seem to work in Excel 2007

I might have misunderstood your scenario. Don't have xl07, but maybe you
could paste a sample of your pivot "as-is" and how you want it to become?
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:365 Subscribers:65
xdemechanik
---