November 28, 2020
apologies again if this is already answered.
When merging the two data sets do they have to have the same column headings - if there are additional columns of data contained in only one data set - when the merge is complete will Power Query add these additional columns on the end of the resulting data set.
Thank you for your help,
July 16, 2010
I suspect you are confusing merging with appending. Appending is similar to copying and pasting data sets one below another. For this the column headers need to be the same in each dataset.
Merging in Power Query is more like performing a VLOOKUP from one table to the next. For that the column headers can be different.