Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
98
Views
Topic starter
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
Posted : 17/05/2023 11:57 am
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
Posted : 17/05/2023 7:23 pm
