7.13 String concatenation and aggregation

 

There is a data table:

imagepng

Now we want to concatenate the ID numbers for each group of names by | to form a string, and put the result in column C (calculate in cell C1):

=spl("=E(?1).new(cum(~~+""|""+ID;Name):IDs)",A1:B13)

imagepng