Power Query in Excel omits rows when appending two tables. How to Fix?

Hi Everyone,   I am new here to the community. I am seeking assistance with an issue that I'm having with Power Query in Excel. I am using power query for the first time, and when I append two tabl...