Excel Data Cleansing & Standardization

I have a collection of Excel workbooks holding mixed text-and-number fields that now suffer from inconsistent date styles, duplicate rows, stray characters, and irregular column layouts. Your task is to take those sheets and return a single, tidy version that is ready for analysis. Here’s what I need done: • Remove all duplicate or empty rows while preserving source integrity • Standardise dates, currency, percentages, and any other numerical formats • Correct common text issues such as accidental spaces, broken line breaks, or mismatched capitalisation • Align and reorder columns so each file follows the same schema • Flag any anomalies you cannot resolve and note the reason in a separate “Issues” tab You may rely on native Excel features, formulas, Power Query, or VBA—whatever achieves a clean, reliable result without altering the underlying meaning of the data. Deliverables: 1. A cleaned and fully formatted master workbook (or set, if more than one is required) 2. A brief changelog noting major transformations and any unresolved items 3. Optional macro or query scripts if you automate portions of the work, so I can reuse them in future Accuracy and traceability matter more to me than speed; I would rather receive thorough work with clear documentation than a rushed file. Feel free to ask for a sample before you begin so you can confirm the scope and complexity.