condensing records

[purepremiumpulp]

I have a table stored in 3NF such as this:

ID GROUP

TOM DIAL
TOM BROADBAND
TOM WIFI
SAM DIAL
SAM BROADBAND

I'm trying to create a query that goes back to a denormalized table where the output would look like:

TOM DIAL, BROADBAND, WIFI
SAM DIAL, BROADBAND

any ideas? thank you

 

[pbaldy]

Not the way I would do it, but here's a method:

http://support.microsoft.com/kb/210163/en-us