Combining rows

[Bing]

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!!

[pbaldy]

A couple of ways:

http://allenbrowne.com/func-concat.html

Return a concatenated list of sub-record values