Getting Power Query to add new values to the bottom

DMO123

Board Regular
Joined
Aug 16, 2018
Messages
96
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!
 

DMO123

Board Regular
Joined
Aug 16, 2018
Messages
96
@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

Well-known Member
Joined
Oct 24, 2015
Messages
3,202
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:

Forum statistics

Threads
1,077,653
Messages
5,335,508
Members
399,021
Latest member
XLReverseEngineering

Some videos you may like

This Week's Hot Topics

Top