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.
Answers
-
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
-
Hi Mark,
Unfortunately that didn't work. I get the following error
#INCORRECT ARGUMENT SET
Ruth
-
Ooops. I see my error. Try:
=JOIN(COLLECT(alimentary@row:diagnostics@row, alimentary@row:diagnostics@row, IS TEXT(@cell), ", "))
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
Help Article Resources
Categories
Check out the Formula Handbook template!
