I will merge excel files and flag duplicate rows

Mexico

I speak Spanish, English

Python, Flask and IoT Project Support

I study Mechatronics Engineering at the Universidad Nacional Autónoma de México (UNAM) and expect to graduate in September 2028. Since September 2024, I have worked with Python, Flask, SQLite and Ardu...
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

My Portfolio