Actions
Time in Hrs
Combine tables/ files with different headers
Katherine Tay
Posts: 1
May 17, 2023 - 1:57 am
1
Hi,
If 1 file contains header A, B, C, D while another file contains header A, B, E, F. How do you use power query to combine these 2 files?
Thanks
Mynda Treacy
Posts: 4515
May 17, 2023 - 9:23 am
2
Hi Katherine,
You can use Power Query Merge to combine these files similarly to how you might do a VLOOKUP to bring columns E and F into file 1.
Power Query Merge with List functions
Mynda
The following users say thank you to Mynda Treacy for this useful post:
Alan SidmanForum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online:
Guest(s) 10
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Devices in use: Desktop (6), Phone (4)
Forum Stats:
Groups: 3
Forums: 24
Topics: 6356
Posts: 27793
Member Stats:
Guest Posters: 49
Members: 32324
Moderators: 3
Admins: 4