Excel 2007 : Combine information for duplicates

[Hayden.hr]

I have a table that has a list of people and all of their earned degrees. There is a separate row with duplicated information (person name, ID #, dept #, ect.) for each degree that the person has received. Many people have two or more degrees. Is there a way that I can indicate that if the persons name is duplicated it will combine the degrees into one field so that I only have one row for each person that will indicate all degrees?

[modytrane]

If you attach a sample workbook it will be easy to implement.
modytrane