Merging Queries

[DFoster_22]

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 trying to combine these two tables so that they roll up together and give me the table that is shown below. 

I have tried merging queries using a Full Outer join kind but that only joins the rows that have similar values in both tables 1 and 2. I have also tried appending the tables and then using the Group By feature and selecting All Rows under the type of operation, but this is not working either. Any ideas on how I can combine tables with a similar but not identical columns?

Thanks.

[Fowmy · Accepted solution]

@DFoster_22 

Please check the attahed file, I pasted my reply and checked the reply of @mahenkj2 , same has been suggested

[mahenkj2]

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.