Forum Discussion
Solved
Merging Queries
Hi there, So I'm trying to merge two tables that have a similar "Event Name" column, but not all the values in the Event Name column are identical. See Table 1 and Table 2 below. I am...
DFoster_22
Please check the attahed file, I pasted my reply and checked the reply of mahenkj2 , same has been suggested
Hi DFoster_22 ,
I can't test now, but try as below:
For each table, at first bring A to G column in one column by unpivot function in power query.
Then append both.
And then pivot the resultant appended table.
Check if it works.