C
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
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