Converse of Subfield

Is it possible to group by one column such that another column produces comma separated list. As another wrote somewhere else
The original data

ID ReportId Email
1 1
2 2
3 1
4 3
5 3
I want to group by ReportId, but all the email should be comma separated. So the result should be:

ReportId Email

Yes, it’s Aggregate with concatenation.

1 Like