View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default 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.