Quick Pivot Table Question

[mr-tom]

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.

 

[Luke M]

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.

 

[mr-tom]

Hi Luke,

Thanks for the reply. The pivot table is actually a query which simply
returns to a pivot, allowing some more layout flexibility and aggregation.

Unfortunately, my mandate is rather restricted - a poorly designed bit of MI
has been created. I can't touch the output itself and as such simply have to
work "between" the data source and the output. My mandate is to rip the guts
out as nobody can understand them and to rebuild it simply. But without
touching the source data or the destination...

Any way, Why would I want it? Simply because on the "presentation" sheet,
each person has their location adjacent to them and therefore if I'm going to
pull it through from somewhere, it would help if each person was also
adjacent to their location on the pivot table.

But thanks for the reply, and if nobody comes up with a way of doing it,
I'll take the answer as "no" and you get the tick!

Cheers,

Tom.