I have a table of data responses to a survey. Gradually, the number of rows grows over time as the number of survey respondents grows. Below is a dummy table of responses for the first 16 people.
Capture1.PNG

I want to create a spreadsheet that automatically gives me the names of the survey respondents who meet certain criteria, as shown below. For example, I want a column with the names of everyone who selected "orange" as their answer to Question #1, a separate column for everyone who selected "green" as their answer to Question #2, and so forth (as shown below). Ideally, the names would be listed in alphabetical order but this is not absolutely required.
Capture2.PNG

Any suggestions?

PS: Attached is an Excel file with the input data, as well as the desired output layout. dummy data.xlsx