Excel Data Cleaning & Formatting -- 2

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.