Concatenate one column into single string

[SergeantJack]

Hello!  I have a single column of text that I need to concatenate into a single string, so this:

Bird

Fish17

81nine42

help!

...should look like this:

BirdFish1781nine42help!

This string will then be used as the start of a line of text further down the workflow.  How do I accomplish this concatenation?

[atcodedog05 · Accepted solution]

Hi @SergeantJack 

Here is how you can do it.

Workflow:

Hope this helps : )

[Priyanka_Ms · Accepted solution]

Hi SergeantJack,

Please find the solution attached.

Hope this helps 🙂

Regards

Priyanka

[Priyanka_Ms]

@atcodedog05  I agree this is the easier way 🙂

Thanks!!

[SergeantJack]

That worked great.  Thanks!