merging data related question

It would be great if somebody could help me out with this problem.
To illustrate I attached a small Excel2007 file.

My data is in colunm set #1.
I want to create from the data set in column set 1 the data set shown in colunm set #2.

I want to automate the process. The program needs to regognize if a name appears only once or more than once. If it appears more than once the data needs to be merged as I highlighted from yellow to green.

If somebody could tell me how to do that that would be wonderful.

Regards,
Detlef