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!
 

Some videos you may like

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

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
4,723
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:

Watch MrExcel Video

Forum statistics

Threads
1,090,226
Messages
5,413,195
Members
403,466
Latest member
sammv

This Week's Hot Topics

Top