Forum Discussion
Combining data from two tables in Excel into one new table
Have been struggling for hours with a task in Excel that should be very simple. I have two tables in Excel in two sheets. They are names tblEx and tblSales, and each have unique records. I wa...
Thank you very much for replying.
I tried your Solution 02.
But the only options I have for getting data from other source is From HTML, From Text, New Database Query [SQL Server ODBC, From Database]. there is no option for Blank Query.
I should probably have mentioned that I work in Excel 365 for Mac.
Peter
Then you need go with the solution number 01, as rightly said by SergeiBaklan currently Power Query for mac is limited.
Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert
If you find the above solution resolved your query don't forget mark as Official/Best Answer & like it to help the other members find it more.