This is how I actually clean data using Power Query

I'M HERE TO HELP YOU LAND YOUR NEXT TECH & DATA JOB 🌐 My website: https://mochen.info/ LET'S COLLABORATE 🤝 Sponsorships & long-term partnerships: https://mo-chen.notion.site/Partnerships-19af8411d7208065bcc5ee1133286714 ABOUT ME I'm Mo and I work as a data analytics manager / content creator. I make videos about how best to get your next job in the tech & data space; whether you're a beginner, career switcher, or someone looking to take their tech & data career to the next level. PROFESSIONAL CERTIFICATES 🖥️ Get 25% OFF DataCamp's Data Analytics and AI courses here: https://datacamp.pxf.io/DataCampMoChen 🏅 DataCamp Certifications: https://datacamp.pxf.io/DataCampCertMoChen 🧑‍💻 DataCamp Data Analyst Certification: https://datacamp.pxf.io/dataAnalystCertDataCamp 🧑‍💻 Data Analyst in Power BI (Microsoft PL-300): https://datacamp.pxf.io/dataAnalystPowerBIMoChen 📊 Data Analyst in Tableau (Tableau Certified Data Analyst): https://datacamp.pxf.io/DAinTableauMoChen 🤖 AI Fundamentals: https://datacamp.pxf.io/AIfundamentalsMoChen ☁️ Microsoft Azure Fundamentals (AZ-900): https://datacamp.pxf.io/az900MoChen ⛅ AWS Cloud Practitioner (CLF-C02): https://datacamp.pxf.io/awsCloudPractMoChen 🌥️ Introduction to GCP: https://datacamp.pxf.io/gcp PROJECT FILES ➡ https://github.com/mochen862/power-query-data-cleaning