Display a list of columns if data is present within?

I have a table with the following data:

Rows: Names of People

Columns: Fruits

Is there anyway to set up a dropdown list with all the names, then in a listing display any columns next to their name with data inside?

ie: there are 6 columns (orange, apple, banana, grape, pear, melon) and Clarence has "yes" under the orange, banana and pear columns. How can I set up a dropdown so it shows all the names, and when you click Clarence it shows, in a list, like such:

Orange

Banana

Pear

)

I've attached a sample workbook.

Thanks for any help!

Crossposted:

excelguru.ca/forums/showthread.php?10999-Display-a-list-of-columns-if-data-is-present-within
old.reddit.com/r/excel/comments/l0lk42/display_a_list_of_columns_if_data_is_present/