Getting Power Query to add new values to the bottom

DMO123

Board Regular
Joined
Aug 16, 2018
Messages
99
Hi All,

I have searched the internet for a solution but cannot find one. can someone help me with Power Query in excel.

so i have separate tables for items which can contain a varied amount of rows. i then have a merged copy of all these individual tables in another tab as one big table. so all table headers are the same etc. its all just merged into one. i am facing a problem where when i add a new value in my individual tables and refresh my merged table the value gets added where the rest of the data sits. normally this wouldn't be an issue but in my case it is as i need new values to be added to the bottom of the table, does anyone know how i can do this?

any help is much appreciated!
 

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
its all just merged into one

to the merged table add custom column with mentioned function. it will give you date and time. sort ascending. remove this column.
now you can add new data into your source table(s) and after refresh you should see new data at the bottom of the result table
 
Last edited:
Upvote 0

Forum statistics

Threads
1,213,494
Messages
6,113,988
Members
448,538
Latest member
alex78

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top