adding text after running power query

[angle_fbi]

I'll set the scene..

I have a daily repot table which contain some transactions. and I run excel power query to combined them on a daily basis and bring them to one table

I need to do one thing..

* I need to be able to add my own data to the end few columns. and i need what i added to be stick to the row . because whenever a new row added before what I added . the text which i added will stay on the same row and will not move with the excat row


Is there a way I can tell it to leave those few columns alone or something along those lines?

[alansidman]

What have you tried and what is the result of those trials?

Can you share a sample file. Read the yellow banner at the top of this page.