How do I combine rows on common fields and add separate columns for differences

[M1ha]

Hi there,

Bellow is a screenshot of a table from my app. 

Is there a way to merge/combine the lines with same IDs and have the emails as separate cells like below?

I tried =Aggr(CONCAT(DISTINCT [Email ],', '), [Name]) but can't find a way to split emails list field into separate columns:

Thank you!

[justISO · Accepted solution]

Hi, I believe you need to create separate columns to have values in each of them, you can create one and show only 'first' email in it with something like this:

SubField( Aggr(CONCAT(DISTINCT Email,','), Name), ',',1)

You can create second column and show only 'second' email etc.:

SubField( Aggr(CONCAT(DISTINCT Email,','), Name), ',',2)