Grouping project names!!!

Hi,
I have a excel sheet with two columns.One with username and the other is projects.Each user has more than one projects.I want to make a new list (In a new sheet)with user name and all the projects the particular user is associated with.How can I do this with a help a Macro?
Thanks...