Data in added columns getting scrambled upon "Refresh All" of external data

[jphalverson]

Hopefully I can make this clear enough.

I have a table that is refreshed, appended, and duplicates deleted from a text file and fills data in column A (SKU Number) and B (Quantity Available), and that is working fine.
I then added Column C (My Price) and entered my cost of each SKU.
If I sort the table by any column, everything stays as it should and My Cost moves with its' appropriate SKU.
If I then click "Refresh All", the query pulls in data from the text file just fine, but every value in My Cost (my manually added column) get randomly shuffled to different SKUs in Column A. The My Cost values aren't just staying in the same row with the wrong SKU, they are moving to totally different locations in the column.

Basic example-
Pre-refresh:
SKU Quanity My Cost (my manually added column)
1 1 $1
2 1 $2
3 3 $3
4 4 $4
5 5 $5

Post-refresh:
SKU Quanity My Cost (my manually added column)
1 1 $3
2 1 $5
3 3 $4
4 4 $1
5 5 $2


So, my real question is: Is it possible to add a column to a table, and have the manually entered data in that column "linked" permanently to the appropriate row after refreshing the data from the external source?

 

[mrshl9898]

You'd need a second table with say SKU and cost, with a VLOOKUP or similar to get that against your table through a formula.