String detail data

[Boo]

I have a report with 2 fields: Grouped on [Name]
Under Detail [Room]

The output looks like this:
John Doe
Rm 100
Rm 200
Mary Jane
Rm 100
Rm 300
Rm 400

Is there a way to make it look like this?
John Doe
Rm 100, Rm 200
Mary Jane
Rm 100, Rm 300, Rm 400

I know how to string fields: [field A]&", "&[field B]
But that does not work here.
thanks

 

[Rich]

Article ID: Q141624

 

[Boo]

Was this Article ID number suppose to help me answer my question?
I typed the number into search but that just sent me to the reports page.
Is anybody willing to give me a little more help?
thanks