Combine Excel Worksheets in Power Query - My Online Training Hub
video description
Date: 2022-04-08
Related videos
Comments and reviews: 10
krrish
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
reply
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
reply
Andy
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.
reply
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.
reply
krrish
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
reply
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
reply
Zor
I loaded 2 databases from different sources on 2 seperate sheets on the same workbook and I am trying to connect them, is it possible? I tried to follow this video but it doesn't seem to list them under tables when I get to the append part
reply
I loaded 2 databases from different sources on 2 seperate sheets on the same workbook and I am trying to connect them, is it possible? I tried to follow this video but it doesn't seem to list them under tables when I get to the append part
reply
Dino
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
reply
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
reply
Vipul
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.
reply
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.
reply
krrish
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?
reply
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?
reply
Nathan
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!
reply
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!
reply
itech
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
reply
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
reply
James
Thank you, Mynda, for another fine video. FWIW-- The audio on this particular video seems distorted here and there, nothing terrible at all.
reply
Thank you, Mynda, for another fine video. FWIW-- The audio on this particular video seems distorted here and there, nothing terrible at all.
reply
Add a review, comment
Other channel videos
