Power Query Data Transformation in Excel

Automate tedious data cleaning, unpivoting, merging, and appending across CSV files and ERP exports with Power Query in Excel.

Syntax & Formula

Data > Get Data > From File / Table

Power Query records transformation steps (Applied Steps) into M-code that automatically re-executes whenever data is refreshed.

Workplace Example

Removing blank rows, promoting first row to headers, splitting names, and merging branch sales tables.

Common Mistakes to Avoid

Editing the raw sheet directly after loading into Power Query rather than letting Power Query maintain the transformation pipeline.

Practise this in the spreadsheet simulator