Power Query and additional manual values in columns

[pedromfpedro]

Hi everyone,

I have a small problem that i can't fix in power query:
I've got a table that works perfectly in that table I've 2 columns to insert values manually. every time that I open the file and update the table in those 2 columns it took the last value in those columns and drag to the last row after updated.
I hope the image helps to solve my problem.

thank you

 

[alansidman]

Pictures of issues are not helpful nor meaningful as we cannot manipulate data in a picture. Please upload your sample data using XL2BB. Then manually mock up your solution so we can see what you want. If you are unfamiliar with XL2BB, then read my signature. Also, supply us with your Mcode as we cannot read your mind nor see your what steps you have taken.