Hello, I have a worksheet that has over 4500 rows and about 20 columns of information. A serial number may be listed multiple times. I am looking to compare the information and if duplicated consolidate the duplicated data to one row.

Here's an example of te worksheet:

ColA ColB ColC ColD ColE ColF
07002 E046 NYNJ EAST 19,581
07002 E046 NYNJ EAST 475.30
07002 E046 NYNJ EAST 950.60

End result I would like to see:
ColA ColB ColC ColD ColE ColF
07002 E046 NYNJ EAST 19,581 1425.90

I DO NOT know how to do macros (Yeah, excel dummy) so I need help. PLEASE.