How to lock variable text in a cell to another cell from PowerQuery

Hi Excel Experts,

I have a list of product numbers which is derived from our ERP system through Power Query.
I added another column in the spreadsheet (not PowerQuery) next to them, to write the responsible for this item.
However when I refresh the spreadsheet and more data is loaded from PowerQuery, the "manual" column doesn't match anymore.
So how can I lock what I write in the last manual column to the product number in column A from PowerQuery, so when I update the list, the manual information will follow the right product number?

Example excel.JPG

Welcome to the forum.

This is an issue I found early on when using PQ at work several years ago. I found and used this solution: https://exceleratorbi.com.au/self-re...s-power-query/

It works well.

Thanks for the kind rep comment.