Categorized Data Entry Task
Budget: ₹750 – ₹1,250 INR
I have several Excel/CSV files that hold a blend of text and numeric fields. I need every record transcribed with 100 % accuracy into a new spreadsheet, but grouped logically by category so the final workbook is easy to filter, pivot, and report on.
All headings, number formats, and any existing cell notes must be preserved. Where a record clearly belongs to more than one category, please duplicate the row rather than forcing multi-value cells—I’ll reconcile overlaps later.
You are free to use Excel native tools, Power Query, or any preferred data-cleaning add-ins, as long as the end result is a single .xlsx file with separate, clearly named category sheets (or a master sheet with a category column if that proves cleaner). Before sign-off I will run a quick spot-check against the original files, so obvious typos or shifted columns will delay acceptance.
Tell me how quickly you can begin and roughly how many rows you can process per hour; I’ll share a small sample first so we can be sure we interpret the categories the same way.
All headings, number formats, and any existing cell notes must be preserved. Where a record clearly belongs to more than one category, please duplicate the row rather than forcing multi-value cells—I’ll reconcile overlaps later.
You are free to use Excel native tools, Power Query, or any preferred data-cleaning add-ins, as long as the end result is a single .xlsx file with separate, clearly named category sheets (or a master sheet with a category column if that proves cleaner). Before sign-off I will run a quick spot-check against the original files, so obvious typos or shifted columns will delay acceptance.
Tell me how quickly you can begin and roughly how many rows you can process per hour; I’ll share a small sample first so we can be sure we interpret the categories the same way.
Related categories:
Visual Basic
Data Processing
Data Entry
Excel
Excel Macros
Data Visualization
Data Analysis
Data Management