Rename columns in Power Query when names change | Excel Off The Grid

★ Want to automate Excel? Check out our training academy ★
https://exceloffthegrid.com/academy


★ Download the example file ★
https://exceloffthegrid.com/rename-co...


★ About this video ★
Power Query is great for extracting data from a source, reshaping it, then loading it into Excel. A standard part of the transformation process involves Power Query using column headers to reference each column. When the column headers change in the source data, it gives us a big problem.

In this video, I share two ways to rename columns in Power Query when the column names change.

Celia Alves video is here:    • How to rename columns in Power Query ...  


★ Download 30 most useful Excel VBA Macros ebook for FREE ★
https://exceloffthegrid.com/


★ Where to find Excel Off The Grid ★
Blog: https://exceloffthegrid.com
Twitter:   / exceloffthegrid  

#MsExcel #PowerQuery