Joining cells of multiple columns into one cell

Ruth Schoonover

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.

Mark Cronk

Hi @Ruth Schoonover ,

Try:

=JOIN(COLLECT(alimentary@row:diagnostics@row, ", ")

Work for you?

Mark

Ruth Schoonover

Hi Mark,

Unfortunately that didn't work. I get the following error

#INCORRECT ARGUMENT SET

Ruth

Mark Cronk

Ooops. I see my error. Try:

=JOIN(COLLECT(alimentary@row:diagnostics@row, alimentary@row:diagnostics@row, IS TEXT(@cell), ", "))

Mark