1000 cell values concatenate to one cell only with delimiter ;

[PassION_es]

Hello Alteryx.

I have a thousand list of email address that I wanted to be concatenated or combined in to one cell only.

Here;

Input:  (all in one column)

aae@gmail.com

bahalaka@gmail.com

unsa@gmail.com

and so on and so forth........

Output:(with semi colon in between those email add) - output to one cell only

ae@gmail.com;bahalaka@gmail.com;unsa@gmail.com

Hope to help me with this.

Thank you in advance.

[usmanbashir · Accepted solution]

@PassION_es - please see attached workflow. Hope this helps!

[PassION_es]

amazing @usmanbashir ,thank you so much!