Good afternoon! Once again I come back to the experts for some assistance. I
can't seem to grasp my head around this to figure it out.

There are multiple entries for multiple people listing different
qualifications, and I would like to combine them to make one entry. Here is
my example:

John Smith 1A
John Smith 2A
John Smith 3B
Jane Doe 1A
Jane Doe 3B
Sally Smith 1A
Sally Smith 2A
Sally Smith 3B
Sally Smith 4B

What I would like to have is:
John Smith 1A, 2A, 3B
Jane Doe 1A, 3B
Sally Smith 1A, 2A, 3B, 4B

Is this possible without the manual work? I have approximately 15,000
entries.

Thank you for any help you are able to provide.