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 [email protected] with the subject title of PIVOT TABLE.

Thanks,
DWH425.