Manual notes in Power Query tables

[Automatrix]

Let's say I have a list of item (B, D, C) that I import into a new table using Power Query, and sort them alphabetically.

Then I add a new Note column, and write a note regarding item B.

Later on, I add a new item to the original list (A), and refresh the query.

The note about B stays in row 2, which now contains item A.

Is there any way to make the note stick with item B?

 

[JGordon11]

Add your note column to the blue input table, not the green output table

 

[Automatrix]

Add your note column to the blue input table, not the green output table

Sadly, that is not an option in my real-world scenarios. The green output table will be much different from the blue input table, and my colleagues will be adding the notes.