removing duplicates from data

Hi All,

I am trying to write a piece of code that helps me to remove duplicates from my data and cleans up the results.
The code should find duplicates in the same colum and copy the data in the rows of these duplicates to one row (the one of the first duplicate). Then it should delete the now empty duplicates and move on to the next set of duplicates.
See the attached file for a before and after.

I hope I make myself clear, any help is greatly appreciated!

Thanks!
Schzuki