How to Concatenate 2 or more column

[Khanzali007]

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.

[Luke_C · Accepted solution]

Hi @Khanzali007 

Here's how I'd do it:

1. Transpose data
2. Filter empty records
3. Concatenate data
4. Join concatenated comments back to dataset

[Khanzali007]

That's, really quick reply, appreciated 

Thank you, It works.

[Khanzali007]

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.

[Kurohits]

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. 

[Khanzali007]

Thank you @Kurohits