I will merge excel files and flag duplicate rows
Python, Flask and IoT Project Support
About this Gig
Do you receive the same report in several Excel files and need one reliable total? I will combine up to three .xlsx files with matching columns (one table per file, up to 1,000 rows total).
You receive one workbook with a master table, a duplicate log and a summary. We agree on the record ID and duplicate rule first. Exact repeats are logged; conflicting values for the same ID are flagged for your decision. I reconcile row counts and one agreed numeric total against the source data.
My gallery shows a demonstration with fictional sales data: 36 source rows, 30 unique sales and six exact duplicates. Please send an anonymized sample before ordering so I can confirm the layout and scope. One revision covers the same files and rules.
Technology:
Excel
Expertise:
Data manipulation
•
Data validation
•
Transformation

