Columns following the Row in an Imported Table

I have imported some data into Excel using MS-Query and an ODBC connection to
an AS/400 and then added a column to the table that allows the entry of text,
Example Column "A" is Customer # (From Database), Column "B" is Customer Name
(From Data Base), Column "C" is a column I added to the table to allow the
entry of a Ranking Code.

The problem is that after entering the Ranking codes they will not follow
the rows when the data is "Refreshed" Example if I enter a ranking on "C3"
and the data in "A3 and B3" get moved down one row on a refresh for a new
customer number then the data I entered into "C3" stays on "C3" instead of
moving down one row with the data that is now in A4&B4, the result is the
Ranking is now on the wrong customer number. Any Help would be appreciated.