Can manually updated fields exist as columns along side Power Query columns?

[Lou Mickley]

I have a table populated by PowerQuery bringing in variable rows from a CSV.  Can I have a column for "Notes" that I update content manually?  Seems when a row is deleted in refresh of CSV, the Notes column does not also adjust and therefore is off one row.

[#2]

Hi Lou,

Nope, that doesn't work such way. Power Query knows nothing about the column you added manually and doesn't sync rows with it.

[#3]

You can have an additional formula column in Excel that will retain information during a refresh. Create a separate sheet with your notes. Link these notes with a VLOOKUP  via a unique key to your source data.