Concatenating values in a View

Hi all

I am trying to construct a view based on two fields in a table. The first field is User, the second is Group. Each User may have more than one Group, so there is a separate record for each Group the user is a member of.

I would like to create a view that has a unique list of Users in column 1, and column 2 has a concatenated list of each Group the user is a member of.

For example, if User Paella is in the ABC, DEF and JKL Groups, the view would display:

Column1 Column2
---- ------
Paella ABC, DEF, JKL

The groups need to be separated by something other than a space.

Any assistance would be much appreciated.