Power Query data refresh and assign previous comments dynamically.

[AnetaSki]

Hi, 

I am Power query beginner and really looking for some advice.

I haveworkbook with two tables- one is loaded power query and 2nd is the table with checking results and formulas. I am trying to think about the way to automatically move my comments stored in the table with formulas on the data refresh in power query table, for example when I add/ remove data these rows from 2nd table are not moving up/down- making comments useless. Formulas as such are okay as they reference the data from loaded power query table dynamically, just the comments that I input manually in the 2nd table are not moving.
Could you guide me what I could do to make them comments moving alongside the data in power query table?

Thanks!

[AlienSx · Accepted solution]

@AnetaSki read this Matt Allington's article about self referencing tables in Power Query.