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 tables together a lot of rows of data are missing in the appended table. What could be causing this circumstance? Any assistance is appreciated!

Thanks