Combine Data From Multiple Worksheets into a Single Worksheet in Excel

[@novidwiastuti9931]

i almost copy paste a column from 1000+ sheets one by one.... NOW I OWE YOU A LOT. THANK YOU SOOO MUCH

[@gudguy97]

that would be so tiring holy shit

[@wrcz]

man people really need to learn that VBA exists. or, well, now Power Query. but for many things, VBA is still the easiest.

[@darlingtons.kolleh3400]

You are real Professor in this field, I want to become a Data Analyst, got my first certificate in MIS and want to specialize in Data Analysis. I have earned my MPA in Public Sector, but Pursing a Career in Data Analytics currently. The next is Power BI. Thank You.

[@MrAlivallo]

Ok I got it. name your sheets as TABLES. Go to DATA--> Get Data --> "NEW SOURCE" --> load your excel files/sheets --> go to APPEND QUERIES !! --> Append as NEW --> Three or more tables --> "Close and LOAD TO" --> NEW SHEET --> Ignore Errors they are typically from blank/null data --> Thumbs UP, YOUR WELCOME

[@RonLaFaye]

I went through 7 or 8 other videos but they all required complicated coding. You made it very easy to understand. Thank you so much!!

[@trumpexcel]

Glad you found the video useful Ron!

[@patolapatola5059]

Over the years I have followed many tutorials and there has never been one I was able to follow along with until now. There were only 2 minor things that were different when I did mine and I believe that is only because this tutorial was done in 2018 and it's now 2020. Thank you so much for this. You are going to make me look like a genius in my boss' eyes.

[@shrs.3448]

Excellent tutor - thank you. Speak at the right speed, not hurrying it, and make following and learning easier. Really appreciate you.

[@gregoryobroin3461]

Plan to use this to combine various bank accounts into one table and pivot the data. Really helpful & easy to understand. 👏

[@adamlazo82]

Great video. Just enough info to be helpful and generate some ideas of my own on how else I can use Power Query to my advantage.

[@devanchandrasekher6986]

Wonderful presentation 👏. Simple, clear, focused. Thanks a ton and God bless 😊

[@kamatchichandran5138]

Great teaching. You have provided sample worksheets to practice which makes anyone to learn without waiting for a minute. Thank You very much.

[@js2556]

Thank you very much Sumit(TrumpExcel) for all the Excel video tutorials. They are very informative and helpful.

[@shriidharkulkarni6648]

Excellent video. The tone of the tutor was very friendly. Thanks.

[@mlcalderaro]

Thank you! This was a fantastic explanation, direct, simple and easy to follow. Appreciate you making me smarter!

[@hannahkeeshan4118]

Your videos are incredible and are so helpful to me as a CPA. Thank you!

[@trumpexcel]

Glad you're finding the videos useful Hannah!

[@nicolecoca955]

Thank you so much, you help our class to passed our assignment. Very well explained.

[@ThalantyrBF3]

Hi TrumpExcel. Just used your video to set up something I've wanted to do for a long time. Extremely straight forward, very easy to follow. Fantastic work. Thank you!

[@charleshazen6287]

Thank you! Very easy to follow, and it solves a major headache.

[@pauls7056]

Wow, you are a born teacher. Fantastic presentation. I was trying to find something on Mac Numbers that does this but I'll be searching in vain! Looks like I'll need to go and buy Excel...again. Thanks for posting.

[@SuhaniSharma-um5pe]

Best video so far for appending data in excel. I had issues with files having different table or sheet names. I watched many video but none told me how to merge tables with different names. I followed this video and it worked. Thanks!!

[@aidaagolli1222]

This was brilliant and saved me from a nervous breakdown! Thank youuuuuu

[@trumpexcel]

Glad you found the video useful Aida :)

[@khalidalvi5436]

@@trumpexcel Same here bro very helpful.

[@michaelpatterson3379]

Well done. Not too short, not too long and you covered some basics as well. Great job.

[@lelanilabuschagne1927]

Thank you so much for your video. You were the only person who helped me alot. The others on the internet did not explain it as you did. :)

[@lesdgama]

Excellent tutorial. Clear explanations and demonstrations.

[@georgieannabrimblecombe4633]

This is genuinely life changing

[@sreedharshiralkar3321]

Best Explanation, I was looking for this. Thank you

[@trumpexcel]

Glad you liked it :)

[@hrithikzgirl83]

Extremely well explained. This saved me so much time. Thank you!

[@garylillich]

Thank you for sharing an Excel workbook for us to do while watching. That sure helps learning a lot.

[@terrydouglasjayasuriya5162]

Great video TrumpExcel. I was going to write a VBA code to achieve this. Many Thanks.

[@djrex4751]

great video! well organized, good examples and easy to follow. Just what i needed, it worked for me!! thank you for sharing!

[@joselara7827]

Oh my brother. I am so thankful for your channel.

[@FLWVideosYT]

Nicely done! Super easy to follow

[@karandabhi3228]

Very much useful👍 This work I did it manually today and now this helped me to ease my work. Will definately try

[@kirpalmann1383]

Thank you very much. This was tremendously useful, and I am grateful that you posted this video.

[@hafizumar4769]

2022 and this video is still saving lives. Wow

[@cagrierdemir]

Many Thanks Man. Your video helped me alot. You made my day. Cheers!

[@mobilechrisd]

You explain things very well. Thank you for making this video.

[@ujjwalgautam1335]

Awesome explanation!! Great Job!

[@hjk4575ma]

Thanks a lot! This saved a huge amount of time for me.

[@mohamedhusain1773]

Excellent explanation , Thank you very much.

[@heather-5666]

This is not what I was looking for but it is a great tutorial. Good job!

[@rihanss]

This is brilliant my friend! this was a great solution of all I know subscribing! you are a superman!

[@coventry-enterprises]

Thanks for the precise explanation. Very helpful.

[@siribn2657]

Learnt recursion from this video, Thanks buddy

[@Tony_Montana659]

NO Words super, thank you . God bless you.

[@marksneade8215]

I can't tell you how much this helped me! Amazing! Thankyou.... :)

[@AbuchiEzeani]

Nice for my data analysis. Thanks alot.

[@francesdobbins2964]

this was a great tutorial. I never thought to use Power Query. I will give this a shot.

[@paola8197]

I can't believe it, I love you!

[@maxlengkong8584]

Thank you for sharing your video. It's so helpful for me.

[@TheNamonama]

Excellent information...thank you so much fr your effort

[@abhishekdsl]

Thank you! This was really helpful.

[@jalalsyednaveed5527]

A life saver dude 🙏🙏🙏

[@ericlawless2696]

This video is helping me so much. There is one problem I found where it was not showing me every sheet within the workbook? How do I fix this?

[@nathalievilela6911]

Perfect explanation. I've never used power query but i'm pretty sure i will start to use this resource soon. Thank you very much.

[@emilytumon1163]

this is the tutorial I like! on the spot!

[@jcrm05]

Great video and beautiful explanation, just what I was looking for. Thank you!

[@geniecy3117]

Brilliant! Helped me a lot with my new project. Thank you.

[@user-js5to4rz2k]

May I know why in the blank query, for sheet 2, it didn’t show “table” but error instead 😢

[@drcthangamani2120]

Thankyou Very much. It is more useful to me

[@leahrosenietes2869]

Very well explained. Thankyou so much.

[@virendrahardiya2797]

Hallo Sumit ji, Your spoken words are already clear to hearing and understanding. Then even u started typing the same on screen in between our View. It's interrupt in to wotching properly full screen.

[@MSHL007]

Very helpful, Thank you very much!

[@sant1811]

woow i have been searching for so long, here it is the right one!!

[@AnhLe-qt2el]

Thank you for the great video. I manage to merge all my tables into 1 table, however column with data (text type) in the source tables turn into null value in power query. can you please help to rectify it? Appreciate much!

[@pallavigavandi9046]

Hi..Thanks it works...My query is I want to combine multiple excel files from multiple folders in 1 master sheet..Can I do that with Power query...

[@forpupo]

Very helpful and easy to follow

[@erinharder4617]

You are amazing - thanks for this - saved me today!

[@ppunais86]

Thanks brother, informative and usefull

[@cliffeby]

Very nice. Took a while to find sine everyone has different definitions of combine, merge, append, etc. Great that it creates the tableName field automatically.

[@MySVGs]

Exactly what I needed. Thank you!

[@anupamsadhukhan5620]

Excellent tutor - thank you

[@TheFamilyJulie]

Thank you!! You just saved me so much time. Excellent job.

[@winnieveloso9531]

Hi, thank you for sharing. this is very helpful. Quick question: Does this work if the tab has different headers? For ex. Tab 1 has Name, Title, Date while Tab 2 has Name, Note, Action

[@jeffmann9235]

i have the same question

[@javiarenas]

It does. But I guess you don't need this information anymore

[@caylemacdonald5142]

Thank you, this was very helpful clear and worked perfect.

[@rakibtaher5419]

Very insightful. Thanks for the help!

[@smasthan1628]

you are genius bro...thanks for wonderful video :)

[@lharisiadis]

Great tutorial, I do have one question. Can you explain why every time I run this query it keeps adding a column and throwing off my data?

[@bulgabattumur3425]

Excellent tutorial! Very useful! Thank you!

[@chitrasrivastava8313]

so well explained

[@tchanchan4745]

Very helpful and informative video- thank you so much for sharing!

[@Mahesh717]

What if we have different sheets with different no of columns & data, then how to extract tables ?

[@parambirsingh8249]

Great Great Tutoial, Thanks dear. Saved lots of time with this.

[@roberth.9558]

Excellent. Thank you.

[@CK-ok4uj]

He is the best!!

[@thurstanwilliams3705]

Very useful. Thankyou.

[@nukenjale]

very much useful, thank you

[@michaelpavlov9493]

Thanks a lot, God bless Your soul.

[@mohamedsahbouni5135]

thank you so much bro!! it's helped me a lot & a lot

[@villiamo3861]

Excellent video - thank you.

[@mandeepsingh-hc8hf]

@2:00 after entering formula it didnot show any result, means no table as shown in the video @2:00, Please help. :(

[@mraqwim]

Hi, thank you so much for sharing this useful tutorial. It really helps!

[@hphuonga6ftu]

Thanks so much for the tip. it's so helpful for a large data file!

[@prashantpotdar6309]

Really nice video Now I want to make one folder and when I copy any new excel file data from this file must be get into master file Pls make video on this

[@mableotinga1402]

Thank you so much. Simple and clear

[@mastifour]

I used the same steps as you shared.

[@RpTheHotrod]

This was very informative. Thank you!

[@MrNaturalcure]

Please explain if selected from drop down tab and enter some data that data should also be written to the relevant sheets correspondingly Thanks

[@philipboruga6862]

I like the presentation however can the article be made zoom and clear

[@ZahoorAhmad-mv1nz]

Thank you very much dear.

[@janikaswanepoel7167]

Hi, thank you for this helpful video. I have one issue, after I added =Excel.CurrentWorkbook() and press enter, the table with all sheets and tables does not appear. What could be the problem?