I want to concatenate the text in different row but exclude a particular
criteria if it comes up. See below example:

Different Scenarios:
A B C D E
1 undecided John John undecided John
2 undecided Paul undecided Paul Paul
3 undecided undecided undecided undecided Lily

RESULTS: undecided John, Paul John Paul John, Paul, Lily

Basically, I only want the "undecided" shows up only if all three options
are undecided; otherwise only give me the name(s) that is/are suggested.

Thanks.

--
M&M