Easiest Way to Combine Data from Multiple Sheets into One Sheet in Excel

[@MissMicrosoft]

Happy New Year everyone! 🎉
A little New Year's favour, will you please give this video a like and subscribe to the channel? This will really help me hit my 2023 goal of 50,000 subscribers! Thank you 🙏 have a great new year!

[@aliyazdi3726]

WoW very good , please insert simple file for test and download /and plz learn diffrent headers /thank you

[@MissMicrosoft]

Thank you, I will add the sample file, in the meantime here is the video for different headers: How to Combine Multiple Files with Inconsistent Column Headers into a Single Sheet
th-cam.com/video/SKskTCNiUIc/w-d-xo.html

[@sajidiqbal7035]

very informative and you made this easy for me. Thanks

[@MissMicrosoft]

I'm really glad it was helpful :)

[@cheikhhakim5864]

Thank you miss for all your videos. Please how can we do if tables have different headers

[@MissMicrosoft]

You're welcome Cheikh, I will make a video on this and let you know once it's released

[@cheikhhakim5864]

@@MissMicrosoft thank you miss i am grateful

[@MissMicrosoft]

Hi Cheikh, here's the video on how to combine tables with different headers, hope it helps! th-cam.com/video/SKskTCNiUIc/w-d-xo.html

[@cheikhhakim5864]

@@MissMicrosoft thank you miss i am very grateful

[@MissMicrosoft]

You’re most welcome :)

[@moncyphilip3688]

Super

[@MissMicrosoft]

Thanks Moncy :)

[@eslamfahmy87]

Thanks alot ..but I need to understand what the difference between (excel.workbook) & (excel.current workbook).
In addition, (Table.combain).

[@BenDieselBasicAutomotive]

Wow!... very detailed explanation.... Thank you very much...

[@MissMicrosoft]

You are most welcome and thank you so much for the support!

[@jhanmichael31]

Very informative! By the way, maam, how do you combine data in 1 row, 2 different columns, but 1 column has multiple rows. Example in Table Format:
Item Code Item
123 laptop
Mouse
Keyboard
How do I make it like this in power query?
Item Code Item
123 laptop
123 mouse
123 keyboard

[@MissMicrosoft]

Hi Jhan Michael, thank you! You would need to use fill down in Power Query, so right click on the "Item Code" column and click "Fill" then select "Down" and the empty rows will be filled with "123" you can also check out this video here: th-cam.com/video/4lVNS83ivsA/w-d-xo.html it shows you how to use Fill Down at about 03:06 minutes. Hope this helps

[@jhanmichael31]

@@MissMicrosoft wow. Perfect!!!! Thank you so much!

[@MissMicrosoft]

@@jhanmichael31 you're most welcome :D

[@jhanmichael31]

Hi @@MissMicrosoft another scenario I have. If I want to move all rows under "Item 2" column to the last row of "Item Code" column. How do I do that?
Item Code Item 1 Item 2
123 laptop Computer
Mouse Monitor
Keyboard Mouse Pad
How do I make it like this in power query?
Item Code Item
123 laptop
123 mouse
123 keyboard
123 Computer
123 Monitor
123 Mouse Pad

[@MissMicrosoft]

Hi Jhan, this one is a bit more detailed, I will need to do a video on it, please hit the notification bell so you know when that video is released.

[@lokeshtimu]

Hi mam
Not able to type "Excel.currentworkbook()

[@MissMicrosoft]

Hi lokesh, please type it as follows: =Excel.CurrentWorkbook()

[@MissMicrosoft]

Don't forget the equals sign

[@BenDieselBasicAutomotive]

There really are people who are gifted in simplifying very complex topics... Thank you very much Mam.... I learned a lot.. Been trying to learn Power Query for a long time.... But after watching you video... I begin to appreciate it...

[@MissMicrosoft]

It's my pleasure, I'm so glad that the videos are helpful!

[@harmeetsingh1991]

Nice info

[@MissMicrosoft]

Thanks Harmeet :)