Forum Discussion
Solved
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 o...
If you are on Excel 2016 or later Power Query is built-in, it's called here Get & Transform under the Data tab.
Did you consider Power Query?
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.
SergeiBaklan oh yeah i confused it with powerview