How to convert a Pivot Table into a Flat File format?
 

I am an Excel 2003 user and have a pivot table just the way I want it.
I would like to take that and convert it into a flat file format
(removing all the row totals, etc).

Is that possible?

I see in the formatting section that all you can do is make it look
'pretty'...

What I am trying to do is take the pivot output, convert to a flat file
to insert into another dataset that I will pivoting from.

How to convert a Pivot Table into a Flat File format?
 

You can turn off the totals, then copy the pivot table, and paste it as
values on another worksheet. There, fill in the blanks, using a
technique shown he

http://www.contextures.com/xlDataEntry02.html

To turn off the row or column totals, right-click on the pivot table,
and choose Table Options.
Remove the check marks from Grand totals for columns and Grand totals
for rows.

wrote:
I am an Excel 2003 user and have a pivot table just the way I want it.
I would like to take that and convert it into a flat file format
(removing all the row totals, etc).

Is that possible?

I see in the formatting section that all you can do is make it look
'pretty'...

What I am trying to do is take the pivot output, convert to a flat file
to insert into another dataset that I will pivoting from.



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