View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Soapydux
 
Posts: n/a
Default Quickie on Pivots

Is it possible to force a pivot table to display the column
information.

Instead if this format

Category 1 Apples
Pears
Grapes
Category 2 Nuts
Raisens



I want to display this instead

Category 1 Apples
Category 1 Pears
Category 1 Grapes
Category 2 Nuts
Category 2 Raisens

Thanks