After creating a pivot table, I am left with the lead category (furthest
to the left) that is summaried. Iv'e tried to cut and paste to give an
example.

Area Item
Asia CF1GB-80-380
CF1GB-80-520E
CF2GB-80-380
CF2GB-80-520E
CF4GB-80-380E
CF4GB-80-520E
CF512-80-380
CF512-80-520E
IR-437
PM-231
RW021-001
WALLET-231
Is there a way to set the pivot so it will fill the blank sections
below Asia with "Asia"? Automatically, not by copy and pasting it in.
This used to be a feature in previous versions of Excel.
Please respond directly to with the subject title of
PIVOT TABLE.

Thanks,
DWH425.


--
dwh425
------------------------------------------------------------------------
dwh425's Profile: http://www.excelforum.com/member.php...fo&userid=3083
View this thread: http://www.excelforum.com/showthread...hreadid=400261