freelancer.com2 часа назадНе указано

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 character…

Budgetот ₹ 750 до ₹ 1,3к
TypFreelance
KategorieНе указано

Angebotsbeschreibung

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

Skills und Kategorien

Data EntryData ManagementData ProcessingExcelExcel MacrosExcel VBAVisual BasicНе указано

Ähnliche Angebote