Match and Condense from Dataset

Hi everyone, hope you're all well.

I'm attempting to condense down a data set. To explain, each row has a Key, and then the following columns have the option of being left blank or filled in with Yes. There can be several rows with the same Key, and for each row the option columns can be different. I'm trying to condense/summarize that so each Key appears once in the data set with all Yes options appearing with it. I'm having trouble getting the formula to index everything that has the identifier, and not just stopping at the first row. Sample sheet should be attached.

Stay safe, and I appreciate any help.

-Mike

You got it, thank you!!!