Help

Combining Lookup values from multiple columns into one column

Topic Labels: Formulas
796 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Darian_Grant
4 - Data Explorer
4 - Data Explorer

Airtable4

I’ve attached an image of a dummy setup. What I’m trying to do is combine the names from “Lookup Participants - Project 1” with the names from “Lookup Participants - Project 2” into one column (the “Combined Participants” column).

My goal is to create a somewhat scalable research repository where each new research project will be able to feed into this “Master Takeaways” sheet, and participants that get tagged with the same “Main Takeaway” (column 1) will appear in the “combined participants” column and then the count in “total count of participants” will reflect that. (the count part, I can figure out, it’s mainly that first issue of getting the participants all into one column)

This second image is what it ideally should look like:
Airtable2

Please help! There has to be a way to do this with formulas. Even if it won’t achieve the exact ideal solution, something close enough would be a help at this point.

1 Reply 1
Darian_Grant
4 - Data Explorer
4 - Data Explorer

Anyooooone? Looks like I’ve stumped the community!