Forgive me if this is in the incorrect forum, please move if so.

I have a fairly simple web query that I pull each morning using Power Query Editor. The table it produces is refreshed each morning, and old data is pushed down, with the new data populating above it.

I added a few standard columns on the side of the table that the query produces.

I populate the non power query columns with some data, but after the query refreshes, that data does not move down with the rows I entered it into. It just stays put.

Is there a way to have my manually added columns stay locked into the rows that that the query produces?