Remove duplicates and merge rows

Closed
Annie1986 Posts 1 Registration date Wednesday December 18, 2013 Status Member Last seen December 19, 2013 - Dec 19, 2013 at 12:03 AM
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