Excel Magic Trick 1412: Power Query to Merge Two Tables Into One Table for PivotTable Report

Download File:
See how to use Power Query to Merge Two Tables into a Single Table, Load as a Connection Only and then build a PivotTable based on the New Merged Table saved as a connection only.

[CANONinDEVIN]

thank god a good video on Excel straightforward and helpful, even 5 years later

[eenksct]

6yrs and this still saves ass. This just saved my ass now

[dolfo]

This is delightful!!!! exactly I was looking for. Simple example. Thanks a lot

[weedr]

Awesome, THAT is EXACTLY what I was looking for! You're awesome dude!

[divyanshugawali]

Thanks. Exactly what i was looking for.

[excelworx]

Hi Mike, please advise how to join 2 tables in PQ, when the transaction table has a cost price. The second table is used to calculate the sales price depending on the cost price in the transaction table. Eg. if cost <1000, unit cost x 1.25, cost between 1001 and 2500, unit cost x 1.30 etc

[abdrahmangalal]

Thank you Mike,
We appreciate your efforts

[saharbabikir]

Amazing video!
Hey I'm trying to build a pivot table and then append underneath it another one, can I?

[tammamhitari]

Thanks brother you solved my problem appreciated

[aoianalytics]

Thanks for this!! How do I bring in OneSalesTable "1 Table" into the spreadsheet?

[Luciano_mp]

Sensacional, mais um vídeo brilhante. Mike obrigado.

[ranjeetdulalneogi]

what will be the reason for the de-active option of Only Create Connection from the import data tab

[universaldot]

When I create the pivot table a Merge1(2) is created and it says "180, 000" rows loaded. Is it because of the large amount of rows?

[artieboy]

Cool! Nice simple explanation. Thanks

[Pawhan]

You are brilliant! Thank you very much

[meteora]

excellent explanation as usual. thank you!

[RaviKumar-prby]

Thanks Mike the same thing I did that in excel but it will take too much time which you do it in minutes.. Thanks

[donvanzandt]

Hey Mike I am having a hard time refreshing the pivots from this video after I have added information to the bottom of the tables i have merged together. Can you or anyone reading point me to the updating video for these power pivots? thank you!

[tommymerelte]

The way you say "Table" remind me of that Discord message notification sound, btw nice content, tks.

[radioteletype]

Can we merge tables from different workbooks instead of putting all the tables on the same worksheet in one workbook?