Combine the Same Field From Multiple Rows 1

[dcsoke]

So I have data that's in the following structure.
ID LINE COMMENT
1234 A Test Line A
1234 B Try Line B
1234 C On Line C

I need to combine it like so:
ID COMMENT
1234 Test Line A, Try Line B, On Line C

I tried a loop, different joins, etc. but the problem is there there could be x number of rows per ID so a standard join won't work. Any ideas?

 

[RTag]

Check this question:

http://www.tek-tips.com/viewthread.cfm?qid=1669348

http://www.R-Tag.com

Viewer, scheduler and manager for Crystal reports.
Send your report everywhere.

 

[dcsoke]

Awesome, thanks guys!