Combine tables/ files with different headers

Power Query

2 Posts

2 Users

0 Reactions

44 Views

RSS

Katherine Tay

(@kattay)

Posts: 1

New Member

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

Mynda Treacy

(@mynda)

Posts: 4756

Member Admin

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.

Mynda

Posted : 17/05/2023 7:23 pm

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed