I have a table with duplicates. I would like it to remove all but one instance of each number, and show me a concatenated version of the other column. Here is an example of what I'm trying to accomplish:
111 John
111 Harry
111 Steve
222 John
222 Steve
333 John
I would like the result to look like this:
111 John, Harry, Steve
222 John, Steve
333 John
Seems easy, but I can't seem to come up with anything. Thank you so much for any help!!