Power query code that combine workbook using column name

1

12Rev79

Board Regular
Joined
Mar 2, 2021
Messages
61
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
Dear Expert,
Please help, I have a bunch of Excel workbook in my folders
I want to figure out the code that combine my workbook base on column names like
Area, Line, Prefix, WBS, Joints, Prep Date, Installed date

Please note that my workbooks has inconsistent sheetnames sometimes is like
Sheet1, Dan, InstallationReport

1741713608388.png

Thanks in advance for your kind help, appreciate.

Regards,
12Rev79
 
Last edited:
You must log in or register to reply here.

Similar threads

1
  • Question Question
Power query to merge workbook base on header names and rename
Replies
1
Views
169
Kaper
Kaper
1
  • Question Question
Power query merge workbooks base on column names
Replies
0
Views
146
12Rev79
1
1
  • Solved
Power query Combine workbook by selecting worksheet name
Replies
2
Views
229
12Rev79
1
1
  • Question Question
Power query code to include Source name
Replies
0
Views
133
12Rev79
1
C
  • Question Question
Power Query - finding named tabs/tables in different workbooks in a folder
Replies
1
Views
443
alansidman
alansidman

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top