I'm not 100% sure, but I would think it's not possible. What puzzles me is
why you want your PivotTable to look like that, as that format is the same
layout of the raw data. Why go through the trouble of creating a PivotTable
if you didn't actually want XL to group things?

Continuing this line of thought, why did you want a repeated label? If you
need it for a formula, I would suggest using the GETPIVOTDATA function, as it
would prb work better.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"mr-tom" wrote:

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.