Hi,
You can use Group By plugin to achieve this.
In Group By plugin configuration, select StudentID as Group field.
Select ‘Type’ in ‘aggregates’ as “Concatenate strings separated by ,”.
This would group data of each students (1 row for each student) and all contact numbers for that studentID separated by comma would be added in new field.
1 Like