sort/filter with drop down, all data showing

[rrupp]

Is there a way to set up a filter that allows me to sort by header but then
show all the data? For example:

Sale's Name Product
Rob gum
Kim gum
Rob brush
Rob gum
Kim turtle

Can I set it up to filter for each header Sales/Product. So, I can email
this to a group and if they want to click on the product header, they can
select from the drop down, gum, and also see that brush and turtle were
products sold by Rob and Kim? And, also, the other way, I can click on Name
and sort filter/sort by Rob but also see all items by Kim?? Hope this makes
sense.

 

[Joel]

the only way I see of accomplisdhing this is to place all the sales people
for a product in additional columns as shown below

Sale's Name Product Sales People 1 Sales People 2 Sales People 3
Rob gum Kim
Kim gum Rob
Rob brush
Rob gum Kim
Kim turtle


Then when you filter you can look to the right to see other sales people. A
macro can be writen to easily accomplish this. You can also do it with a
formulas but I prefer macros.