How to combine in a folder multiple files with different column headers - T0030

What if you need to combine the same type of information that you receive from multiple sources, but each source sends you the Excel report with different column names? Here is one possible solution with Power Query in Excel that renames the columns in all the files in a folder to get them ready to be combined in one data table only. Our previous video:    • How to rename columns in Power Query that ...   M Code Functions : Function Table.RenameColumns - https://docs.microsoft.com/en-us/powe... Function List.Zip - https://docs.microsoft.com/en-us/powe... ----- Learn how to AUTOMATE YOUR EXCEL REPORTS in minutes instead of hours without copy-paste or coding: https://snapreportschamp.com/course Get this ready-to-use Excel solution for 2 and 3 columns of Dependent Dropdown Lists: https://solveandexcel.ca/dynamic-depe... --- Get access to the EXERCISE FILES by joining our Telegram Group at https://t.me/celiaalvessolveexcel Subscribe to my NEWSLETTER for exciting news about the Excel world: https://bit.ly/learnfromcelia Learn how to automate your Excel Reports: https://snapreportschamp.com/ Enroll on my Excel Automation Training Program: https://snapreportschamp.com/waitinglist Boost your Excel skills with the best Excel books - Mr Excel Book store - https://www.e-junkie.com/ecom/gb.php?... Celia Alves - Microsoft MVP & Certified Excel Expert, Solutions Developer Solve & Excel Consulting - https://solveandexcel.ca LinkedIn:   / celiajordaoalves   Facebook:   / solveandexcel   Twitter: @celia_excel Instagram: @solveandexcel YouTube: https:www//   / celiaalvessolveexcel   #excel #msexcel #exceltraining #msexceltraining #powerquery #powerquerytraining #dataanalysis #snapreports #solveandexcel #automation #reportautomation #VBA