Combine Excel Worksheets in Power Query

[najlas.]

So so useful!! Thank you for being so generous and so effective while explaining!!

[leorc]

maybe 5 years later, congratulations, it is a fine material on how to use Power Query

[adighose]

Mynda - your videos are very good, thanks for sharing these videos

[TheOndricek]

Very helpful. Great to see good practical uses for these tools. This really helps me visualize how I can use it in my day to day tasks. Keep them coming!

[leorc]

excellent video, nice and clear, simple and fun with Mynda, thanks a lot to show Power Query, it values more than 389 likes, certainly.

[VipulKarkar]

That was a quite lengthy method.

You can use Merge table instead of Append table.

Merge based on 3 columns and in just 2 clicks it will give same output.
Great to see your powerquery tutorials.

[ymoatassimbillah]

This is very amazing.. thanks a lot !
انه رائع جدا..شكرا جزيلا!

[ShermAppel]

Thank you, Mynda, for another fine video. FWIW-- The audio on this particular video seems distorted here and there, nothing terrible at all.

[kuldeepwahi]

Hi Mynda, this is great, i was wondering can we use PQ for 12 months/Qtr budget and comparison with Actuals for number of Branches and then consolidating the same into States and further consolidating as company and all of it can then be automated by refreshing the source data, happy to share a work book or take up a course recommended.

[peterharbman]

Clear and precise, thank you so much!

[sibbs]

Firstly, great videos - you have been a life saver. Could I possibly ask you to please do a video on combining non-related tables. I am trying to update my subtotal cost with a variable profit rate that may change from time to time. [sub total]*Variable Cell in another sheet. Hope that makes sense.

[emanuelmbassi]

Hello Mynda your videos are very useful
I need your help on the following situation.
Everyday I´ve to download my company bank transactions(more than 100) per account, to update my bank statement in Excel.
so I have 10 bank accounts which means 10 different excel download, then I have to load it in a single excel file with one sheet per bank account.
How do I use power query in this situation?

[DinoAMAntunes]

Hi, Please i am Trying to find an example for Cartesian Product in Power Query. Multiple tables with multiple column in the same workbook, with some equal transformation and some diferents. Any example please. Tks in advance

[arturoguzman]

You should do more videos about power query 😍

[krrishpaul]

thank u for ur reply but this is not exact what I need .my problem is that I hv 1000 employee's salary sheet in different worksheet for 12 months in random order in rows and I want to add employees salary in a single sheeet in single cell whitout moving in different sheet .is there any solution for this? thank u

[krrishpaul]

i have one problem ...how i can add values in one cell combining the values from different worksheet in a single file which contains repeat name and different values of corresponding name? can you help me ? demonstrating some example? thank you

[zzzzzzzzzzzzzzzz]

So i've built my first data model and need help with two things:

Undestanding relationships
My refresh is really slow on the data model

[krrishpaul]

is it possible by using sumproduct(sumif(indirect.... how it works to add everymonth salary in a single cell of employees.is there any other formula for same outut?

[ihabsaad]

Good day. How I can make “Undo” in Power Query. Many thanks 🙏🏻

[krrishpaul]

suppose from january is month1 and december is month12 so there is 12 sheet.