1. Cleaning CSV Data
Data AnalystBackground
A dataset contains inconsistent spacing around entries, causing issues during import.
Problem
Leading and trailing whitespace in thousands of rows.
How to use
Paste the data, set Trim Type to 'From Both Sides', and Trim What to 'Whitespace'.
Outcome
All entries are perfectly aligned without extra spaces, ready for database import.