Formula to join two lists

Questions and Help
1

Hi,

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

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

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

2

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?

3

Thank you Gaurang!

Yes, its fine to have it in visible order.