This is how I actually clean data using Power Query

Data Analysis Lab - Build Your Data Portfolio in 30 DAYS: https://www.skool.com/data-analysis-lab How I Built 50+ Data Projects in 90 DAYS: https://mochen.info/50-projects-90-days/ Join my newsletter: https://www.mochen.info Sponsorships: enquiries@mochen.info Hi! I'm Mo, and I help career switchers transitioning into Data Analytics. I'm a Data & Analytics Manager, and I've been working in the Financial and Banking Data space for 7 years now. COURSES & CERTIFICATES Get 25% OFF DataCamp's Courses & Certificates: https://datacamp.pxf.io/DataCampMoChen INDUSTRY RECOGNIZED CERTIFICATIONS Data Analyst Certification Program: https://datacamp.pxf.io/dataAnalystCertDataCamp PowerBI Data Analyst Certification Program: https://datacamp.pxf.io/PowerBIDataAnalyst Data Scientist Certification Program: https://datacamp.pxf.io/DataScientistCert SQL Associate Certification Program: https://datacamp.pxf.io/SQLAssociateCert TOP DATA ANALYST COURSES Data Analyst with Python: https://datacamp.pxf.io/dataAnalystWithPython Data Analyst with PowerBI: https://datacamp.pxf.io/dataAnalystPowerBIMoChen Associate Data Analyst in SQL: https://datacamp.pxf.io/AssociateDataAnalystSQL TOP DATA SCIENTIST COURSES Associate Data Scientist in Python: https://datacamp.pxf.io/AssociateDataScientistPython Associate Data Scientist in R: https://datacamp.pxf.io/AssociateDataScientistR TOP DATA ENGINEER COURSES Data Engineer in Python: https://datacamp.pxf.io/DataEngineerInPython TOP BUSINESS INTELLIGENCE COURSES PowerBI Fundamentals: https://datacamp.pxf.io/PowerBIFundamentals Tableau Fundamentals: https://datacamp.pxf.io/TableauFundamentals TOP PROGRAMMING LANGUAGE COURSES Python Fundamentals for Data Science: https://datacamp.pxf.io/PythonFundamentalsDataScience Python Fundamentals for Programming: https://datacamp.pxf.io/PythonFundamentalsProgramming SQL Fundamentals: https://datacamp.pxf.io/SQLFundamentals R Programming Fundamentals: https://datacamp.pxf.io/RFundamentals TOP AI COURSES AI Engineer for Developers Course: https://datacamp.pxf.io/AIEngineerDevelopers AI Engineer for Data Scientists Course: https://datacamp.pxf.io/AIEngineerDataScientists Developing AI Applications Course: https://datacamp.pxf.io/AIApplications PROJECT FILES ➡ https://github.com/mochen862/power-query-data-cleaning