Merge Data - Multiple Rows to One Row

[fenhow]

Hi, I am trying to merge data from multiple rows into one row for each unique ID. Does anyone have an example that I can replicate on how to do this on a table, maybe a query or something like that. Attached img shows what I am trying to do.
Thanks.
Fen

 

[vbaInet]

You need two things:
1. A query to return distinct Last and First names
2. The following code:
http://allenbrowne.com/func-concat.html

 

[fenhow]

Great, that worked well. Thank you. Have you ever used this code? The only issue now is I have a single table that has the same scenario where I need to group many rows into one with a common key but the code you send works with relational tables on a one to many situation. Is there a way I can do the very same thing on a table with no relationships?
Thanks.
Fen

 

[vbaInet]

I don't exactly use Allen Browne's Concat function, I write mine. The logic is similar anyway.

The function should be used on a sorted query not a table.