Drop Down Sorting by Column and Row

[pfm05]

I have a list of people (in column B) and their favorite colors(in Row 2). I want to be able to have a drop down that will create a table that will show everyone with favorite colors of either red blue, green etc... I also want to be able to select the person in the column to see the colors they listed. How do I do that in the most efficient way?

Source Data

.......Red......Blue......Green.....Yellow.....Purple.....Black.....
Joe ...1...................... 3...................................... 2
Bob ...............4.................................... 2 ............1
Sue ...............1......... 3.......... 4

Example of Result after Sort

........Black.......Yellow
Joe.....2
Sue..................4
Bob ....1




Thanks!

 

[Norie]

Please don't duplicate posts.

Zack has already responded here.

I realise it's not a solution but it does tell you how to post an example of your data.