pivot tables - generating 'shortlists'

[cves]

Hi all,

I have a spreadsheet that has a variety of 'fields', split into column
ie.
name | address1 | address 2 | priority | zone

I have created a pivot table that shortlists based on the priority an
zone fields. Problem is, I can only get the 'name' data listed in th
result rows, and not the associated address data. The ideal is to b
able to generate as follows;

Pivottable
priority - select from a dropdown (done this)
zone - select from a dropdown (done this)

name1 - address1 address2
name2 - address1 address2
name3 - ....

Any ideas

 

[Debra Dalgleish]

You could use an AutoFilter, instead of a pivot table. There are
instructions in Excel's Help, and here:

http://www.contextures.com/xlautofilter01.html