How to Concatenate 2 or more column

How to Concatenate 2 or more column into one with ampersand (&) where ever there are more than 1 comment/remarks.

Refer column A to I (Input data)

Refer last column J - which is expected the result from Alteryx.

Also check upon the column J highlighted with yellow color, where 2 comment are concatenate with ampersand (&).

Thanks in advance.

Workflow

Datasets

Tips and Tricks

Optimization

Accepted answers

Hi @Khanzali007

Here's how I'd do it:

Transpose data
Filter empty records
Concatenate data
Join concatenated comments back to dataset

New Workflow4.yxmd

All comments

Hi @Khanzali007

Here's how I'd do it:

Transpose data
Filter empty records
Concatenate data
Join concatenated comments back to dataset

New Workflow4.yxmd

That's, really quick reply, appreciated

Thank you, It works.

Hi @Luke_C I have one question posted, but not answered till now, can you please help me out. I will mark you there, so you can get notified with that post.

Hi @Khanzali007

I know I am bit late for this post but just wanted to share another method of doing this. Attached workflow also for you reference.

How to Concatenate 2 or more column.yxmc

Thank you @Kurohits

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703