Colum mismatch

SDVN yes there definitely is a way.  Please follow these simple steps:

1. Go into Power Query by clicking on Transform Data. Your Power Query table will look like this:

2. Duplicate the query so you have two version.

3. In Table1, remove Column 6 and Column 7, then click on "Use First Row as Headers" under the Home ribbon.  Remove blanks or nulls, and add an "Index Column" starting from 1. Your output should look like this:

4. In Table2 (the duplicate query), remove Column 1 to Column 5.  Then, filter out all blanks so there are no more, then "Use First Row as Headers". Once you have done that, add an Index Column starting from 1. The output will look like the below:

5. Go to Merge Queries (or Merge Queries as New) and apply the following:

6. In the new Merge1 query, go to the far right column which will be your Table2 column and click the expand button. Untick "Index" and "Use original column name as prefix" and click ok.

7. Your new table is as below:

Hope this helps 🙂

Theo