Getting excel to retain manually written comments, even when data refreshes from odata feed.

[Flaminia]

Hello 

I have an odata feed running into an excel spreadsheet which populates various columns and refreshes every time I open it. However, I want to add a comments column that will allow users to add notes against each row and for those comments to remain with the row, even when the data refreshes and new lines of data are added from the feed. 

Is there a way of doing this?

Thanks

[#2 · Accepted solution]

@Flaminia 

The workaround is explained here Self Referencing Tables in Power Query :link:- Excelerator BI

[#3]

Thank you @Sergei, that's perfect. I really appreciate your help.

[#4]

@Flaminia , you are welcome, glad to help