Formula to join two lists


What is the formula to join two lookup columns as text string?

Right now, I used concat formula but it shows like this

What can be done to show simple text value comma separated?

Hey Pratik! Are you looking for something like this: join(merge(Lookup, Lookup2), ", ")?

merge will merge all your lists in a single list, and then join will output a string out of all of them.

Also, do you want to group related rows together? For example: in your example first row, do you want to pair cs.pratik with jane_doe and marsh with john? Or is it fine to output them in the same order as visible on screen?

Thank you Gaurang!

Yes, its fine to have it in visible order.