Forum Discussion
Ocasio27
Feb 12, 2020Iron Contributor
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...
- Feb 14, 2020
If you are on Excel 2016 or later Power Query is built-in, it's called here Get & Transform under the Data tab.
Ocasio27
Feb 14, 2020Iron Contributor
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
SergeiBaklan
Feb 14, 2020Diamond Contributor
If you are on Excel 2016 or later Power Query is built-in, it's called here Get & Transform under the Data tab.
- Ocasio27Feb 14, 2020Iron Contributor
SergeiBaklan oh yeah i confused it with powerview