Hi All,

Hopefully somebody knows the answer to this one, but I can't work it out.

I'm using Excel 2007 and have created a pivot table that has location and
name as row titles, e.g.

London Tom
Charles
Harry
Edward
Bath Jane
Roger
etc

There are also column titles and values but these aren't relevant to the
question.

The pivot table is displayed in tabular form, i.e. Location is a column to
the left of Name.

As you can see in the example above, each location is only listed once,
adjacent to the first person within it.

So the question is this - how can I get it to be listed against each person,
e.g.

London Tom
London Charles
London Harry
London Edward
Bath Jane
Bath Roger
etc

I've looked around for ages and can't find a setting for this.

All help appreciated, even if it's just telling me that it can't be done
because at least then I'll know to stop trying!

Cheers,

Tom.