Merge Duplicate/Similiar Rows Keeping Data In Same Columns

After sorting and filtering rows with in a set range I will have several rows that are almost duplicates. This is normal and expected due to how the workbook is used. Among these rows also will be several single rows that are not duplicates. It is important that I combine any two duplicates into one row. Example:

CREATE TABLES LIKE BELOW?
ABC D E F G H I J K

1 NameA 0XX15930777PS101300PS9

2 NameA0XX15930777PS91200PS10

3 NameX1159XXP555FBX1545PS9

4 NameB0A1234P123PS101263PS9

5 NameB1A1234P123PS90512PS10


What I need is this end result:

CREATE TABLES LIKE BELOW?
ABC D E F G H I J K

1 NameA 0XX15930777PS91200PS10PS101300PS9

2 NameX1159XXP555FBX1545PS9

3 NameB1A1234P123PS90512PS10PS101263PS9


It�s important that the data in each column stay with in that same column. Also of course it needs to be on the same row with the same person (NameA and NameB). The Columns that would determine if it�s a duplicate are D and E �. I would need this to be preformed via macro or some easy way so that others will not have a hard time. It will be on a protected Shared Workbook with Excel 2003. I've enclosed a Sample. How can I sort these or accomplish this and maintain the data where it needs to be?