Combine duplicate rows with unique values

Hi,
I have a lot of data with same values and some blank cells. Please note that if duplicate rows are there, they contain only unique values. There are no duplicate rows with different values in same column cell. It's either same value or blank. There is no different value. Kindly view the sample file if you feel I'm not explaining well.
I've got it working with a macro, not quite right...
I searched everywhere and all I found was combining values those unique values into one cell like A,A.
Thanks & Regards,