Dynamic data sheet combined with one static

[Patark]

Hi,

I am using a sheet in excel which pulls data out automatically from a database. Fills in maybe 20 or so columns with orderinfo.

In column A i have a unique order no.

What i want to achieve is adding a column for an example C that is static. I fill in a number related to the order and i want it to stick with all the other rows connected to the orderno.

If i would create a new column right now (fill in text) and when the file updates the text will not match the correct columns, due to the file getting filled with new orderinfo.

Any help would be really appreciated

Thanks!