The OP would like to be able to add new items to a table that is produced by Power Query. Issue is that after the original table was produced, additional columns are added. When the new items are added then the data in the additional columns is orphaned. The before is the green/white table on the Labelling data sheet in the file attached to post #7 and the after is the same table in the file attached to post #9.
https://www.excelforum.com/excel-for...ml#post5891481