Dear all, i am pivotting large lists of equipment required for a construction
project, and cannot get excel to display labels correctly.

i.e:

if i have a room, with 2 items in it, the pivot table will only display the
room label once, below is a simplified summary of my pivotted data:

Room:  Item:  Quantity:
1a        Desk      1
1b        Desk      2
          Chair      1
1c        Desk      1

therefore, i must copy the room code "1b" down into the empy cell next to
"chair".
this is proving so time consuming when dealing with thousands of items.
i can get excel to merge labels (by ticking 'merge labels') but i cannot get
excel to copy labels into blanks (if there is such a command)

please help.

Regards, Martin