Colummn of Text not following the Rows of Imported Data

[JWGoldfinch]

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

The problem is that after entering the Ranking codes they will not folow 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.

 

[Andrew Poulsom]

This relates to a pivot table, but you may be able to adapt it:

http://www.mrexcel.com/forum/showthread.php?t=382474

 

[JWGoldfinch]

Thanks, I will reseach this a little to see if it will work. You would think there would be an easier way, since is you calculate a new column in a table it will follow the rows, it is only Text that does not as far as I can tell.