This might be a bit of a newbie question. Hopefully there's an easy answer:
I'm loading data into Excel from an external data source using Power Query. In the resultant table in Excel, I want to add a column where I can enter my own free-hand data (text), which does not exist in the source.
If I add a column to the table in Excel, populate it with text, then the source changes in a way that inserts a row higher up in the table on refresh, it doesn't push the values of my manually added columns down the corresponding number of rows and they no longer line up with their original rows.
I tried adding an extra column to the query with the value null but on refresh it just wipes the data I entered.