Aligning dynamic email address

Question

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 Answer

@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 Answer

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