Excel SKU Reconciliation & Deduplication

I need an experienced Excel data specialist to tidy up my product master. The May 20th workbook is the baseline; the current workbook must be compared against it, SKU-by-SKU, using each COSKU’s unique ID to pinpoint anything my CSRs have added since that date. Once the new SKUs are isolated, two additional Excel files from Procurement and Sourcing come into play. From those, I only want the Product Category and Product Line columns—but they have to be translated into my own normalized product-line naming before you paste them in. Type, Size, Neck Finish and any other missing attribute fields should be populated with the standard default values I will supply. After the merge: • Guarantee one—and only one—row per COSKU. • Eliminate true duplicates, yet double-check Category and Line first so nothing valid is lost. • Leave every other column exactly as it appears in the May 20th baseline; no unintended edits or re-ordering. Deliverable: a single, clean Excel file that contains every part number with a COSKU, all newly added SKUs correctly classified, defaulted attributes filled, and zero duplicates. I’ll review the finished workbook with a quick row-count and spot-check, so accuracy must be 100 %. If this sounds straightforward to you and you’re comfortable with VLOOKUP/XLOOKUP, Power Query or similar reconciliation techniques, let’s get started.

Project ID: 40539665