When I add a blank column with values "null (Number from Notes)" in power query editor to my existing data and load it to the worksheet, I'll type some data into the blank column while in the worksheet. However, after I refresh the query, my data is overwritten and my column is blank again.
How can I stop data from being overwritten when I refresh?
I assume the problem is with the value I originally selected in power query editor.
