How to merge column values in different collections?

[Kamini123]

I have a collection(Coll1) like below-

Name Notes
Kathie "Doing good in English"
Samuel "Bad in English"
Mac "Well done in testing"
Kathie "Average in Math"
Mac "Good at coding"

Now, I want this data in other collection (Coll2) like below-
Name Notes
Kathie "Doing good in English, Average in Math"
Samuel "Bad in English"
Mac "Well done in testing, Good at coding"

Basically, I want to merge all the notes for common names here by separating them with comma or bullets, and then send an email including all the notes for that person.
I tried merge collection and some other solutions but they just merge the rows and not just the values in a specific field.

Can anybody please help?
Thanks in advance.

 

[Nehil]

I suggest you should apply filter first using wildcard like 'Kathie*'. Get the value you want to merge in one collection and then merge them.

 

[himavantht]

1. You need to find distinct names first
2. Call one by one and filter collection
3. Manipulate the filtered collection row by row and merge "Notes" with "," and assign to the "Name"
4. Next Name in the loop and same process

 

[Kamini123]

1. You need to find distinct names first
2. Call one by one and filter collection
3. Manipulate the filtered collection row by row and merge "Notes" with "," and assign to the "Name"
4. Next Name in the loop and same process

Thanks. Sorted it in similar way.