I've blogged on this several times, but each time the solution has been a little unwieldly for one reason or another.
The job is to take a set of rows:
And return a comma separated field.
Solution below