Examples of my data file:

SKU: 99999
Item: widget
Color: blue
Location 1: 5
Location 2: 3
Location 3: 4

The problem that I am having: this client has many duplicate sku's (each with their own quantities). The duplicates need to be combined and one (of the two) needs to be deleted.

Thanks, Randy