Aligning dynamic email address

[Kallis]

Hello friends

I want to align the incoming dynamic email address as given in the output.

Incoming

abc@yahoo.com

ponting@gmail.com

dravid@gmail.com

bumrah@outlook.com

siraj@outlook.com

unique@yahoo.com

Expected Output

abc@yahoo.com ; ponting@gmail.com ; dravid@gmail.com ; bumrah@outlook.com ; siraj@outlook.com ; unique@yahoo.com

Kindly let me know how this can be achieved.

[abacon · Accepted solution]

@Kallis You can use a cross tab to easily achieve this. You will concatenate them using the semi-colon as the separator.

Bacon

[Pilsner · Accepted solution]

Hello @Kallis 

If you are trying to combine multiple rows from a single column into a single cell, I typically use the summarise tool. 

In here, you can select the action as concatenate and then specify your separators at the bottom. I believe this will achieve the result you're after. 

Having said that, I do like @abacon's solution too, I always forget the crosstab tool can be used in situations like this!

Hope this helps.

Regards - Pilsner

[Kallis]

Hi @abacon @Pilsner 

Thanks for your solution. Both of them worked perfectly.

[Pilsner]

Brilliant! Thanks for the feedback @Kallis