I have a table (NSCH) that contains two fields, Id and College which tracks the colleges (College) attended by students (Id) and may contain multiple records for each unique Id. I would like to output a table that has two (2) fields, a single record for each Id and a field that concatenates all the colleges.
NSCH looks like this:
200100 UNC
800500 UVA
800500 VT
I would like the output to look like this
200100 UNC
800500 UVA, VT
I have looked at many looping examples but do not understand, is there an easier way to get the result?
Thank you in advance for helping!