Alphabetical Mixed Data Entry
Budget: ₹12,500 – ₹37,500 INR
I have several Excel and CSV files that contain both text and numerical fields. I need every record transferred into one master worksheet, checked for obvious entry errors or duplicates, and then sorted alphabetically by the primary name column.
Scope of work
• Open each source file, verify the column headers match, and combine them into a single workbook (Excel format).
• Enter any missing values exactly as supplied, preserving number formats and special characters.
• Remove accidental line breaks or extra spaces so the sheet stays clean and searchable.
• Sort the final sheet alphabetically and provide a quick pivot or filter view so I can jump to any letter instantly.
• Spot-check totals or counts to confirm nothing was lost in the merge.
Deliverable
One clean, alphabetically ordered .xlsx file plus the original combined CSV for reference. If you prefer working in Google Sheets, that is fine as long as the final download opens flawlessly in Excel.
Accuracy is essential; please double-check before delivery.
Scope of work
• Open each source file, verify the column headers match, and combine them into a single workbook (Excel format).
• Enter any missing values exactly as supplied, preserving number formats and special characters.
• Remove accidental line breaks or extra spaces so the sheet stays clean and searchable.
• Sort the final sheet alphabetically and provide a quick pivot or filter view so I can jump to any letter instantly.
• Spot-check totals or counts to confirm nothing was lost in the merge.
Deliverable
One clean, alphabetically ordered .xlsx file plus the original combined CSV for reference. If you prefer working in Google Sheets, that is fine as long as the final download opens flawlessly in Excel.
Accuracy is essential; please double-check before delivery.
Related categories:
Visual Basic
Data Processing
Data Entry
Excel
Data Cleansing
Data Analysis
Data Integration
Data Management