Joining cells of multiple columns into one cell


I would like to gather the row responses in the columns outlined in red into the column outlined in green so that I can display just one column in a report instead of several. I have the following format I am starting from. It works well for rows with only one response to gather. It doesn't work for instances where there are two responses per row. (For example, the second row in the image below)

=IF([Alimentary]@row = "Alimentary", "Alimentary", IF([Anesthesia]@row = "Anesthesia", "Anesthesia" (etc, etc.)

Admittedly I am a formula rookie so I appreciate the help.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!