Joining cells of multiple columns into one cell

05/06/21
Answered - Pending Review

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.

Popular Tags:

Answers

Sign In or Register to comment.