Thanks again! Your videos continue to be an invaluable resource. Today's challenge: I had a 50+ table spreadsheet that would have taken hours to cobble the appends for manually. It took 2 minutes after watching your video.
I enjoyed watching this video and recommend others to watch. Host seem to be extremely knowledgeable and expert in Excel He has designed the course I feel extremely good. Worth paying to buy the course. With this sample video I learned a bunch. Thanks for educating the community and appreciate your volunteership. Keep posting some more videos. Thanks a bunch
Thank you for all of your work...I've learned more Excel in the last 6 months reviewing your videos than I thought possible for general use. I've been using MS spreadsheets since Multiplan and gained a deeper knowledge from your videos than in all my previous years combined...
In my opinion "Excelisfun" is a "One Stop Shop" from where we can get all important knowledge of other "Masters of Excel" with the reference as well as links, in addition to your original splendid work. You are unique among the best.
You always select practical and applicable examples which always help in solving our problem, in addition to that ..... your wonderful spirit...... TBL :)
Thank you for the kind words! Good examples are as important are good knowledge and good presentation! For me, I can never remember stuff unless it is a good example... TBL!!!!! : )
Thanks for showing how to filter out the name of the table/sheet where the PT is. In my every time I added a new worksheet it would create a new instance of the query called AllTables2, AllTables3 and so on!! One day I will visit Seattle and look for you for a handshake!! Loll
Wow! Good stuff - very enlightening. I might be naïve, but I think MS would just write some code that allows for the selection of more than one Excel Table in a workbook. On the ribbon it could be 'Get & Transform, From Multiple Tables, select Tables. Let's hope for it.
Yes, that is similar what I said in this video: I don't understand why they don't have such an option. My guess is that it will be in a future version of Get & Transform.
Loving these Tuts (would be great to follow them 1 by 1, from the very first, any recommendations/suggestions how to do so??), but having the current workbook feature is REALLY helpful. Anyway you can append new column headings too. Easy with a predefined number of worksheets, but how can you utilise this more "dynamic" approach when adding new sheets. Cheers
Você é bem vindo! Obrigado pelo seu apoio incrível do excelisfun Channel :) You are welcome! Thanks for your awesome support of the excelisfun Channel : )
Você tem meu apoio, há mais de 5 anos..Obrigado pelo grande trabalho que faz!! You have my support, for over 5 years..Thank you for the great work you do !!
Dude, this is extreme beast mode! Googled this topic for hours before I got something useful. Is possible to do this kind of union without converting your worksheet to a table first?
I do not know how to do it from worksheets in current workbook using Power Query. As is mentioned at the beginning of the video, this feature imports the objects; Table, Print Range, Defined Names, Filtered Ranges.
Can we still append data when the column name are in different positions in other excel file. My task is to append data from multiple excel sheet though the column name are same but they are placed in different positions
Excellent and very informative video.... something I have been looking into .... need to know if you have 2 tables in 2 different files we also append the data in either file or a new file?
I would use Excel.Workbook([Content]} in an extra column from a new workbook. I have a few videos on that topic. Here is one: Power Query #08: Import Multiple Excel Sheets From Multiple Excel Workbooks th-cam.com/video/yL11ugShdrk/w-d-xo.html
does the column name(or header?) should always be same?? in my case, i have 2 columns, table1 (description, Date) and table2 (description, date2) appending always result to append(description, date, date2) is there a way to combine the date and date2 into 1 column? TIA!!!
Hello. I have a problem. When I append after the 3er table is added, it comes out with the columns in different places ( the first two columns on the left from the original table, moves all the way to the right creating and extra columns that the first two tables dont have, so it comes with null in the first two and in the 3er table since the first 2 columns moved to the right now are empty and comes with nulls. In other words it just moves my table columns. Is this a bug? Thank you for your help
Hi, I am a fan of urs video and really learnt a lot of things from you, I am stuck in one problem with my excel work if u could help me. can u give me ur email ID to explain what is needed pls i would really appreciate ur support
Just use Power Query Unpivot. Here is video: Excel Power Query #10: UnPivot Feature to Create Proper Data Sets (2 Examples) th-cam.com/video/JfuFGMfgvfY/w-d-xo.html
Thanks again! Your videos continue to be an invaluable resource. Today's challenge: I had a 50+ table spreadsheet that would have taken hours to cobble the appends for manually. It took 2 minutes after watching your video.
Yes!!!!!
I enjoyed watching this video and recommend others to watch.
Host seem to be extremely knowledgeable and expert in Excel
He has designed the course I feel extremely good. Worth paying to buy the course.
With this sample video I learned a bunch.
Thanks for educating the community and appreciate your volunteership.
Keep posting some more videos.
Thanks a bunch
Thank you for the kind words! : )
Thank you for all of your work...I've learned more Excel in the last 6 months reviewing your videos than I thought possible for general use. I've been using MS spreadsheets since Multiplan and gained a deeper knowledge from your videos than in all my previous years combined...
You are welcome! I am glad that the videos help!!!
Dziękuję za kolejną - niezwykle przydatną porcję wiedzy.
I hope you liked it!
In my opinion "Excelisfun" is a "One Stop Shop" from where we can get all important knowledge of other "Masters of Excel" with the reference as well as links, in addition to your original splendid work. You are unique among the best.
Thank you VERY much for the kind words!!!! I appreciate them, and will continue to post fun Excel videos and Excel Workbooks! : )
This is impressive video. And your explanations are on top level.
You are a perfect teacher!!!
Thanks for all your commitment!!!
Thank you for the kind words. But most importantly, thanks for always teaching me awesome things about Get & Transform!!!
Totally agree with Bill
The way you are presenting the concepts is amazing. Thank you so much
Thank you for the kind words! You are welcome for the video!
this is amazing Mike sir m loving it 👍👍👍👍👍👍👍👍👍👍👍👍this is short but very useful nd I understand to easily
Glad you like it, vijay : ) : ) : ) : )
You always select practical and applicable examples which always help in solving our problem, in addition to that ..... your wonderful spirit...... TBL :)
Thank you for the kind words! Good examples are as important are good knowledge and good presentation! For me, I can never remember stuff unless it is a good example... TBL!!!!! : )
Teaching By Love
Yes!!!! WE can make a difference in the world if, when we do stuff, we do it with love!!!!
Thanks for showing how to filter out the name of the table/sheet where the PT is. In my every time I added a new worksheet it would create a new instance of the query called AllTables2, AllTables3 and so on!! One day I will visit Seattle and look for you for a handshake!! Loll
Wow! Good stuff - very enlightening. I might be naïve, but I think MS would just write some code that allows for the selection of more than one Excel Table in a workbook. On the ribbon it could be 'Get & Transform, From Multiple Tables, select Tables. Let's hope for it.
Yes, that is similar what I said in this video: I don't understand why they don't have such an option. My guess is that it will be in a future version of Get & Transform.
As i always love to comment for your videos.... you are awesome mike..
Thanks thanks thanks for everything thing you have contributed
You are welcome, welcome, welcome!
I love you, man!
thanks a lot Bill...great job as usual...but today i am not able to replicate with my own datas🤔
Thanx for all the Power Query videos
You are welcome! PowerQuery is Fun!!
Loving these Tuts (would be great to follow them 1 by 1, from the very first, any recommendations/suggestions how to do so??), but having the current workbook feature is REALLY helpful. Anyway you can append new column headings too. Easy with a predefined number of worksheets, but how can you utilise this more "dynamic" approach when adding new sheets. Cheers
Excel can do many thing that an information system can not :-) Thank you mike great job
You are welcome!
Você faz um trabalho incrível com Excel. Mike você é o cara...Muito Obrigado..
Você é bem vindo! Obrigado pelo seu apoio incrível do excelisfun Channel :)
You are welcome! Thanks for your awesome support of the excelisfun Channel : )
Você tem meu apoio, há mais de 5 anos..Obrigado pelo grande trabalho que faz!!
You have my support, for over 5 years..Thank you for the great work you do !!
Excellent video.. Thanks a lot.. I have a peculiar problem that I cant get around .. Could you help me please??
Can I use a defined range? My template has merged cells, which excel does not like for defined tables.
Awesome Mike with EXCELlent video
You are welcome!!! Thanks for your continued Support : )
Dude, this is extreme beast mode! Googled this topic for hours before I got something useful. Is possible to do this kind of union without converting your worksheet to a table first?
I do not know how to do it from worksheets in current workbook using Power Query. As is mentioned at the beginning of the video, this feature imports the objects; Table, Print Range, Defined Names, Filtered Ranges.
Not in Power Query... Thanks for the support with your comment, Thumbs Up and Sub : )
Thanks for the connection only tip.
You are welcome. Yes, Connection Only is often the most efficient way...
That is fantastic, but for person who doesn't have the power query, is there any way to do this quickly???
Try this question site: mrexcel.com/forum
Can we still append data when the column name are in different positions in other excel file.
My task is to append data from multiple excel sheet though the column name are same but they are placed in different positions
Excellent and very informative video.... something I have been looking into .... need to know if you have 2 tables in 2 different files we also append the data in either file or a new file?
I would use Excel.Workbook([Content]} in an extra column from a new workbook. I have a few videos on that topic. Here is one:
Power Query #08: Import Multiple Excel Sheets From Multiple Excel Workbooks
th-cam.com/video/yL11ugShdrk/w-d-xo.html
Thanks - will try it.
Hi Mike you do not have to refresh 2times. Just Go to the data tab Connections "refresh all" and Boom the table and pivot table get updaten
Does that really work!?!?!? It does NOT work for me.
IT only works when you load The table into the data Model. The Powerpivot Table refreshes automatically... My fault..
I wish it did work, because the double refresh doesn't make sense. It seems like an easy fix for Microsoft!
does the column name(or header?) should always be same?? in my case, i have 2 columns,
table1 (description, Date) and table2 (description, date2)
appending always result to append(description, date, date2)
is there a way to combine the date and date2 into 1 column?
TIA!!!
Great video. Thank you.
You are welcome - glad you like it!!! Thanks for the support with your comment, Thumbs Up and Sub : )
Thank you ...! I just subscribed... :)
You are welcome - glad you like it!!! Thanks for the support with your comment, Thumbs Up and Sub : )
I could have used CurrentWorkbook today.
It still is today! Go For It Oz!!!!
LOL! I've already done the work and submitted the invoice.
But this is definitely in my arsenal now.
Awesome!
Hello. I have a problem. When I append after the 3er table is added, it comes out with the columns in different places ( the first two columns on the left from the original table, moves all the way to the right creating and extra columns that the first two tables dont have, so it comes with null in the first two and in the 3er table since the first 2 columns moved to the right now are empty and comes with nulls. In other words it just moves my table columns. Is this a bug? Thank you for your help
It sounds like the columns do not have consistent names or maybe there are extra spaces.
ExcelIsFun The simplest mistake (column names) Thank you for your help!!
Hi, I am a fan of urs video and really learnt a lot of things from you, I am stuck in one problem with my excel work if u could help me. can u give me ur email ID to explain what is needed pls i would really appreciate ur support
For back and forth dialog try THE best Excel question site: mrexcel.com/forum
+ExcelIsFun can you pls have a look on my query?
m.facebook.com/story.php?story_fbid=1302489379761055&id=100000000163589
Just use Power Query Unpivot. Here is video:
Excel Power Query #10: UnPivot Feature to Create Proper Data Sets (2 Examples)
th-cam.com/video/JfuFGMfgvfY/w-d-xo.html
+ExcelIsFun as always "You are just best"