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

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

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

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

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

Great video! Thank you, Brother. 🙏

Thanks brother you solved my problem appreciated

Thanks. Exactly what i was looking for.

Thank you Mike, We appreciate your efforts

Amazing mike 👍🏻👍🏻👍🏻👍🏻👍🏻

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

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

Thanks Mike. Great video

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

Fantastic. Thanks for this

Great job Mike, thanks.

You are a hero.

You are brilliant! Thank you very much

Thank you. Excel is Fun

Cool! Nice simple explanation. Thanks

Thank you very much!

Many, Many thanks. Mike

excellent explanation as usual. thank you!

Thanks for sharing !!

This was exactly what I needed.

Awesome! Thanks a lot!

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

Thank you mikeee

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

Thanks a lot for this video .... Sir Can you please make a video on Referential Integrity in Excel... ?? And how to declare Primary key and foreign key in Excel.... Not in Access

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?

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

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

Brilliant..

Great method Mike. What happens the second month when there is another set of tables? Will all the merging steps be remembered, or should another method be used?

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!

Thanks with a hope to watch soon a new video on "Importing multiple Excel workbooks with multiple worksheets" after recent improvements in PQ. ;)

Thank you, is there a way to merge more than two tables?

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

Hello Mike, will Power Query work without table feature of source tables? Thanks

Thanks, Mike. Would it be a good idea to re-arrange the playlist so it shows the videos with basic stuff (like this one) at the top, and the advanced stuff (like creating functions in Power Query) at the bottom? When I share this playlist with beginners, they would have little or no idea about the techniques, and such a build-up from simple to complex would help them a lot. What do you think? Best, Ibrahim

I get an error when I try to access the files with the links provided. Great videos!

Is there a reasons my "Only Create Connection" would be greyed out?

Too fast. Hard to understand.

2024. Thanks men!