Data to the right of my query won't stay with the corresponding data

I have a data set that I am importing to Excel using an ODBC connection. I have information to the right of the created table that adds detail to that corresponding record. However, when I refresh, Excel doesn't keep my details with that corresponding record. Is there any way to bypass this, and still allow refreshes to load more records to my data set?

I think this is only possible either with VBA or PowerQuery.

you need another table (shadow table) which has the same data as your import table but including your additional columns.
Each import must trigger a refresh which adds only new imported data to your shadow table.

Hi Gue2013, thank you for that.

I'm not too familiar with the concept of a shadow table. Is it a direct reference (=) to the original table?

It is not a reference, it is a copy.
in VBA:
the first time: copy the data to another sheet or area and add here your details to each record (final table). This is the table you want to work with.
following imports: compare the imported data with your "final table" and update each record (row) and add new data at the end of the table.

in PowerQuery (less effort compared to VBA):
there are a few infos on the WEB. I always use https://exceleratorbi.com.au/self-re...s-power-query/

If you still use MS-office 2013 then you have to install it. In later versions PQ is already included.

Gue, this is amazing. Thank you so much for these resources. I have not had the chance to work with Power Queries prior to this, and spent the majority of the week trying to figure it out. The solution it seems just to work just fine, as the blog says, until you get to duplicate data. I don't have duplicate values in my source data, but since my data is connected to our work order system, every time I refresh, the Power Query is appending another full record set of work orders to my existing list.

I'm going to continue researching until I get it--thanks again for all the help!

Happy that I could help you