Append selected columns to Master table, with different headers in Power Query

Hi,

Thanks for the solution rajendraongole1 offered, and i want to offer some more information for user to refet to.

hello navafolk , if you want to append the data, you need to have the columns that have same name in each table, so you need to make sure that   column names  in the sub table to are the same as the column names in main table thay you want to apped.

and if you want to include the sub table name in main table, you can consider to put the data files in a folder, then use the foloder connector , then it will display all table names, you can refer to the following link.

Power Query Folder connector - Power Query | Microsoft Learn

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.