Microsoft Query- new query results not inserting new row in Excel table

Hi, guys. I frequently lurk these forums for Excel help, but I've finally encountered a problem that I can't find a solution to.
This issue is with the query results obtained from the Microsoft Query Wizard.

I use the query to generate a list of identification numbers based on specific criteria from another document, and then in a second column I use a VLOOKUP to match the identification number to a name. In a third column I enter by hand, with no formula, the location of this object.

Sample query results with VLOOKUP and hand-entered data:
query_issue_1.png

I have the Microsoft Query set to "insert entire rows for new data..." but this is not what is happening. When a new result is returned in the Query column, the third column is not moved down.
query_issue_2.png

It's like the query is inserting new cells, but not new rows, when it imports new data. The VLOOKUP data is formula-based, so it's unaffected, but the hand-entered data is simply not staying "linked" to the correct identification number.

Here's what I'm trying to get the sample to do:
query_issue_3.png

Where the new row that is inserted actually shifts the older data down.

Is this possible to solve while still using the Microsoft Query data? The original document is changed frequently, and trying to map the changes manually is difficult, which is why the "auto-updating" from Query is what I'm trying to use.

Maybe use PowerQuery (Get&Transform) built-in for Ex2016 instead of QueryWizard

Power Query for

• Excel 2016 or Excel 365 is built-in, aka Get&Transform
• PowerQuery works with M-language and does not contain any classic formulae or vba code
• What is PowerQuery? see here: Getting Started with PowerQuery (Get&Transform) in Excel

sandy- I tried using Power Query instead of Excel Query Wizard, but I'm still experiencing the same issue where the cells with hand-entered data aren't 'shifting down' when the query inserts a new row.
(but I do like how Power Query works more than I like how the Query Wizard works, so thank you for that recommendation)

Do you have any more suggestions on how to ensure the hand-entered data cell stays 'linked' to its original row when Query inserts new data?

Sorry for delay, I was away for few days from here.
I think you can try on VBA sub-forum because with Query Wizard or PowerQuery, whatever you choose, it do do that what you want, means mixing manual and automatic.