Getting Power Query to add new values to the bottom

[DMO123]

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!

 

[sandy666]

maybe use DateTime.LocalNow() then sort asc

 

[DMO123]

@sandy666 sorry for not understanding fully im no expert with this (As you may be able to tell) where and how do i add this?

 

[sandy666]

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

 

[DMO123]

@sandy666 thank you i got it working!

 

[sandy666]

you are welcome

have a nice day