join field values in a GROUP

I couldn't come up with a good subject!

Basically I'd like to group my results and combine one field into a string separated by a character.  Given this data:

 [ID] [VALUE]  1     'red'  1     'blue'  1     'green'  2     'red'  2     'yellow'   

I would like to have a Saved Search that would output the following:

 1 'red,blue,green'  2 'red,yellow' 

So I would group by the ID and then (string)join the VALUE fields together with a specific character or string.  I swear there is a way to do this but I can't remember or figure it out.  Anyone know?