Remove duplicates and merge rows

[Closed]
Report
Posts
1
Registration date
Wednesday December 18, 2013
Status
Member
Last seen
December 19, 2013
-
A B C D E
2000 Mary 123 street1,street2
2000 James 123 street2
2000 Mary 123 street1 2.8
2002 James abc street2
2003 Mary abc street1,street2 1.8

I have above data.I have to select row1 and row3 as duplicates,as column A and Column C are same and column D is similar.
Then I need to collect most details.

The result expected is
A B C D E
2000 Mary 123 street1,street2 2.8
2000 James 123 street2
2002 James abc street2
2003 Mary abc street1,street2 1.8

Please suggest a macro as the number of rows is quite large