Merging columns with a delimiter

[Inactive User]

Hi, I am trying to merge 3 columns and include a delimiter.

Example data:

Type 1	Type 2	Type 3
a	b
b
c
a	b	c

My current method is to use the formula tool to generate a new column 'Types' with [Types]=[Type 1] + ', ' + [Type 2] + ', ' +[Type 3]

However this leaves multiple ', ' in many rows and it looks quite messy.

Would anybody be able to provide a solution that would allows me to merge columns and include a delimiter without this happening?

Thanks

[atcodedog05 · Accepted solution]

Hi @Inactive User 

Here is a workflow for the task.

Output:

Formula:

Trim(Replace(Trim([Type 1]," ") + ', ' + Trim([Type 2]," ") + ', ' +Trim([Type 3]," "), ", ,", ", "),", ")

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[Inactive User]

Thank you that works perfectly!

[atcodedog05]

Happy to help 🙂 @Inactive User 

Cheers and Happy Analyzing 😀

[PJ10]

I have exactly same issue but the challenge I am facing is that instead of 3 columns, I have around 28 columns. Can someone help?