Combining Lookup values from multiple columns into one column

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.

Anyooooone? Looks like I’ve stumped the community!

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.