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 feat...

Навыки и категории

Похожие предложения