M
M&M
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.
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.