Merapikan

I have a collection of raw spreadsheets that need to be transformed into a clean, consistently formatted dataset. The files currently contain mixed date styles, inconsistent text casing, and other small issues that make reporting difficult.

Here’s what I need:
• Identify and remove duplicate records
• Standardize dates, numbers, and text casing across all columns
• Correct obvious typos or mis-aligned entries without altering legitimate data
• Deliver the cleaned file in its original format along with a brief change-log that highlights any major corrections or assumptions made

Accuracy is essential, and I’d like the finished dataset to be ready for immediate analysis or upload into a database. If you’re experienced with Excel, CSV handling, and quality-control techniques, I’m looking forward to your help.