Forum Discussion
Merge columns of tables
I have 2 tables in 2 different sheets. I would like to merge both inside a 3rd table (as reference values), however I want one of these tables to be on top of the otherone, and after all values are over, then the other starts at the bottom. Also If i add values to the first table, it should move down all those values of the second table.
Is that possible?
If you are on Excel 2016 or later Power Query is built-in, it's called here Get & Transform under the Data tab.
9 Replies
Did you consider Power Query?
The problem I am having with powerquery is that if I move the file to another place, it will not find the query. In my case the tables I am using in the query are located inside the workbook file itself and if I move the file or share it, the query wont work anymore. Another problem is that I have to save the file and then refresh the query which is not a major problem but its annoying.
Is that for any file or for some specific one? All these looks strange. Perhaps you may submit small sample file with such queries to check the issue is in queries or in your environment. Or both.
Its not showing on my excel, this computer is new but not personal so IDK if there is a free way to add power query as a non-admin. I can access power pivot but i cannot find a way to do that with pivot
If you are on Excel 2016 or later Power Query is built-in, it's called here Get & Transform under the Data tab.
