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

Опубликовано: 08 Октябрь 2024
на канале: Celia Alves - Solve & Excel

34,837

900

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 ...

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