Create a systematic process for normalizing inconsistent data in spreadsheets including date formats, naming conventions, units of measure, and categorical values.
## CONTEXT Data inconsistency is the silent killer of spreadsheet analysis. When "United States," "US," "USA," and "U.S.A." all appear in the same country column, every pivot table, COUNTIF, and VLOOKUP produces incorrect results. McKinsey research shows that data workers spend 60% of their time finding and cleaning…
Premium Prompt
Unlock this prompt — and all 30,000+ expert-crafted prompts — with Pro.
Unlock with Pro