Forum Discussion
Can manually updated fields exist as columns along side Power Query columns?
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...
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.