Power Query
An ETL (Extract, Transform, Load) engine used for data-cleaning and Data Transformation within excel and Power BI.
Core Capabilities
- Automates repetitive data manipulation workflows.
- Manages large-scale datasets where manual excel intervention is impractical or inefficient.
- Data Cleaning Techniques:
- Provides automated steps for removing blank rows, serving as a scalable alternative to go-to-special or Filter methods.
- Reference: 2026 04 26 Excel Blank Row Deletion Go To Special Filter Power Quer (via leila-gharani)