After importing records from an excel spreadsheet, I need to consolidate records which have the same unique ID. In this case, "consolidate" means ending up with one record (from 2 or more with the same Unique ID) wherein the consolidated record's fields, where applicable, would be the sum of the same fields from the individual records.
For example, starting out with this record layout:
...would be processed to ultimately end-up with a record set like this:
How can this be done?