Help Requested - Deletion of Duplicate Lines Possible?

Hello All,

I have a huge file with many different part numbers (36,000 +). The part numbers are duplicated on multiple rows but each row includes a part number plus unique description information. I.E.:

.....A...........B.........C..........D...........E
1 part xx ..................purple........
2 part xx .................4 inches......
3 part xx ...............acme brand....

What I want to do is to delete the duplicate row number but still keep the unique info associated. i.e.:


.....A.........B.........C..............D.............................E
1 part xx.............purple, 4 inches, acme brand

Does anyone have any idea of how I can do this? I have already tried auto-filter and keeping unique records but I loose the "4 inches" and "acme brand" info rows that is vital for my report.


Any help would be appreciated,
Thank you!
-stressed and confused.