iosiflupis
New Member
- Joined
- Jan 26, 2022
- Messages
- 39
- Office Version
- 365
- Platform
- Windows
I have three different power queries that I would like to merge. They share column names but there are some column names that are only used in one table and not the others. I am working on a mapping table in excel. I was going to use the table with the most column names and pull the other two into that table. How do I set up the query so that the tables without the fill to the main table, and how do I pull in the column names that are not in the main column?
Here is a portion of the table that I will be working with:
Here is a portion of the table that I will be working with: