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