Airtable Cobuilder is here! Learn more about our new no-code app creation feature, powered by AI on the Airtable Academy

Combining Lookup values from multiple columns into one column

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


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:

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
4 - Data Explorer
4 - Data Explorer

Anyooooone? Looks like I’ve stumped the community!