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.
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.
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
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!
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.
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!!
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!
i almost copy paste a column from 1000+ sheets one by one.... NOW I OWE YOU A LOT. THANK YOU SOOO MUCH
that would be so tiring holy shit
man people really need to learn that VBA exists.
or, well, now Power Query. but for many things, VBA is still the easiest.
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.
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.
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!!
Glad you found the video useful Ron!
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
Thank you so much, you help our class to passed our assignment. Very well explained.
Excellent video. The tone of the tutor was very friendly. Thanks.
Excellent tutor - thank you.
Speak at the right speed, not hurrying it, and make following and learning easier.
Really appreciate you.
Thank you very much Sumit(TrumpExcel) for all the Excel video tutorials. They are very informative and helpful.
Plan to use this to combine various bank accounts into one table and pivot the data. Really helpful & easy to understand. 👏
Wonderful presentation 👏. Simple, clear, focused. Thanks a ton and God bless 😊
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. :)
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!
Best Explanation, I was looking for this. Thank you
Glad you liked it :)
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.
This is brilliant my friend! this was a great solution of all I know
subscribing! you are a superman!
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!!
Thank you! This was a fantastic explanation, direct, simple and easy to follow. Appreciate you making me smarter!
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.
Great teaching. You have provided sample worksheets to practice which makes anyone to learn without waiting for a minute. Thank You very much.
Great video TrumpExcel. I was going to write a VBA code to achieve this. Many Thanks.
Thank you! Very easy to follow, and it solves a major headache.
Many Thanks Man. Your video helped me alot. You made my day. Cheers!
This is genuinely life changing
Extremely well explained. This saved me so much time. Thank you!
Learnt recursion from this video, Thanks buddy
Very much useful👍
This work I did it manually today and now this helped me to ease my work. Will definately try
Awesome explanation!! Great Job!
Thanks for the precise explanation. Very helpful.
Nicely done! Super easy to follow
Your videos are incredible and are so helpful to me as a CPA. Thank you!
Glad you're finding the videos useful Hannah!
Thanks a lot! This saved a huge amount of time for me.
Thank you for sharing your video. It's so helpful for me.
Excellent information...thank you so much fr your effort
You explain things very well. Thank you for making this video.
you are genius bro...thanks for wonderful video :)
I can't believe it, I love you!
Oh my brother. I am so thankful for your channel.
Very well explained. Thankyou so much.
NO Words super, thank you . God bless you.
Excellent explanation , Thank you very much.
Thanks brother, informative and usefull
2022 and this video is still saving lives. Wow
Very helpful, Thank you very much!
Thank you very much. This was tremendously useful, and I am grateful that you posted this video.
Thankyou Very much. It is more useful to me
A life saver dude 🙏🙏🙏
Excellent tutorial. Clear explanations and demonstrations.
Nice for my data analysis. Thanks alot.
Very insightful. Thanks for the help!
Exactly what I needed. Thank you!
You are amazing - thanks for this - saved me today!
this is the tutorial I like! on the spot!
Excellent tutor - thank you
so well explained
Well done. Not too short, not too long and you covered some basics as well. Great job.
Very helpful and easy to follow
Thanks buddy.. really helpful
Very useful. Thankyou.
This was brilliant and saved me from a nervous breakdown! Thank youuuuuu
Glad you found the video useful Aida :)
@@trumpexcel
Same here bro very helpful.
very much useful, thank you
Excellent. Thank you.
Thank you for sharing an Excel workbook for us to do while watching. That sure helps learning a lot.
This is not what I was looking for but it is a great tutorial. Good job!
Good work👍
thank you so much bro!! it's helped me a lot & a lot
Thanks. Great explanation!
I can't tell you how much this helped me! Amazing! Thankyou.... :)
Thank you so much. Simple and clear
Nice explanation
Thank you, this was very helpful clear and worked perfect.
Excellent tutorial! Very useful! Thank you!
@2:00 after entering formula it didnot show any result, means no table as shown in the video @2:00, Please help. :(
He is the best!!
Thank you very much dear.
Brilliant! Helped me a lot with my new project. Thank you.
well done mate , thanks
Thank you , very helpful .
Awesome. So helpful. Thank you!
great job!
Awesome video. Thanks for sharing!
great video! well organized, good examples and easy to follow. Just what i needed, it worked for me!! thank you for sharing!
Ohhh thank god, u made this video
Thank you Sir, it really helped me
Thanks a lot, God bless Your soul.
tq sir very clear.. keep post video sir
this was a great tutorial. I never thought to use Power Query. I will give this a shot.
Omg, such a good tutorial. Thank you!!
great video!!
This was super helpful, thank you!!
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.
Great Great Tutoial, Thanks dear. Saved lots of time with this.
Very helpful and informative video- thank you so much for sharing!
woow i have been searching for so long, here it is the right one!!
Great, many thanks.
Excellent, thanks
This was helpful! Thanks.
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!
Awesome video
Thank for this video