It's easy enough to add the data after it has been generated by the Pivot
table, but that usually involves breaking the Pivot table links though. Do
you need it to remain dynamic?

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------




"Soapydux" wrote in message
oups.com...
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