I have one data set coming from a database and I have a table inside the excel file. They both have the same columns.
I would like to combine them not by making INNER JOIN of two columns, but by doing a UNION (I am using SQL terms, but I hope it's clear).
Is this possible via the POWER PIVOT or some other way?
Thanks
Bookmarks