There are probably many ways to accomplish this,
one way is to concatenate strings:
IF [Car]="N/a" THEN "Car " ELSE "" END
IF [House]="N/a" THEN "House " ELSE "" END
IF [Married]="N/a" THEN "Married " ELSE "" END
IF [Kids]="N/a" THEN "Kids" ELSE "" END
To get the commas in between will take some extra logic.
I started it in the attached, but didn't take into account all the combinations.
Not sure if this will work for your true setup, but there may be some
benefit in pivoting your four columns into one:
I tried that on the second sheet.
Please see workbook v2019.1 attached in the Forum Thread:
325494concat_v2019.1.twbx 43.9 KB
Thank you so much for this guidance, this was the push in the right direction I needed!