Excellent!. Especially the showing of the two different methods to get the same info. Needed the first example to see how to update/change a "bad" query. Thanks again.
1 steps: showing how to add from a worksheet (not a table) was very useful. Thanks for that information. This is very useful as not all the data we use are in table format. Thanks once again.
Appreciate your efforts and free sharing of such invaluable knowledge in a poper manner. Small suggestion, if the things didn't get repeated in consecutive videos..
Thanks for the video. I can see the "Delimeter" and "Data Type Detection" options in one file but can't see in another file while importing the data from txt file. How to resolve? Please help
i have a question,if we connected the way you connect and we close the first Excel file the source is it will say error or smth like that , which mean that the source has been colsed the the Excel will not provide you the data ,is it true?
hallo Sumit, thank you for specific videos for each option in power query. On Excel workbook, does it allow to upload all types of excels like xlsb, xlsm, xlxs, xls and so on.
Hello Sumit Sir, Can we use power Query to combine data either from several workbooks Or several sheets from several workbooks. Also the important scenario is all data Has no relation with each other's. Actually I'm looking to import data from a total of 5 workbooks and approx more than 30 sheets. If there is a way to connect with you I can explain the requirement in more detail
thanks a lot for your efford but have a question for another case related to that one. So I have that Sales Data file which we pull the datas to the other sheet in the video,ok. But lets say I also have another file which I just only have SOME of those item's name in it, not all of them. Imagine, I only want to pull quantity and price colum of those Items that I have in my file .How can we do that? I hope you would record a video of that case too or guide me . Thanks.
Hi Brother thank you for sharing valuable knowledge. Recently I followed your channel I need one help bro regarding power query excel pls help this case
Hello very useful info.. I will buy you coffee.. Can you let me know how we can import only specific columns into another sheet specific columns,. eg. from Sheet1 I want columns C-E to be import in Sheet 2 column F-H
Hi sir. Let's say, I have to add additional column (Ex. Status) as text. Whenever there is a change to the source like insert new rows in the middle or at the end, it shift the status that make record is not correct. Can you suggest the approach to fix it?
Hi Sir, Thank you for your efforts. One issue I saw is when you changed the data type as percentage, in excel it was still shown as decimal. Is that normal? Another issue is my system date is DDMMYYYY format but while pulling data from text, I saw the format changed to MMDDYYYY. How to resolve it sir?
![Noob To Max With DRAGON REWORK In Blox Fruits [FULL MOVIE]](http://i.ytimg.com/vi/LnBMOinoOvA/mqdefault.jpg)
Excellent!. Especially the showing of the two different methods to get the same info. Needed the first example to see how to update/change a "bad" query. Thanks again.
Excellent presentation. Organized, to the point, well-explained. Thank you.
Massively useful, thanks for taking the time to create this!
1 steps: showing how to add from a worksheet (not a table) was very useful. Thanks for that information. This is very useful as not all the data we use are in table format. Thanks once again.
You are one of a kind Sumit. Thats'f for sure.
Awesome
Man. I just love Indian people
Thanks so much.
Where do i get free excel sheet to practice myself
Thanks. Very succinct explanation and useful to a current project I'm developing.
Appreciate your efforts and free sharing of such invaluable knowledge in a poper manner. Small suggestion, if the things didn't get repeated in consecutive videos..
is it possible to create a macro to do this task?
excellent
Thanks for the video.
I can see the "Delimeter" and "Data Type Detection" options in one file but can't see in another file while importing the data from txt file. How to resolve? Please help
Does the source file have to be open for the destination file to update?
i have a question,if we connected the way you connect and we close the first Excel file the source is it will say error or smth like that , which mean that the source has been colsed the the Excel will not provide you the data ,is it true?
It should work even if the other file is closed
hallo Sumit, thank you for specific videos for each option in power query. On Excel workbook, does it allow to upload all types of excels like xlsb, xlsm, xlxs, xls and so on.
Yes it will allow other Excel formats as well
Hello Sumit Sir,
Can we use power Query to combine data either from several workbooks
Or several sheets from several workbooks.
Also the important scenario is all data Has no relation with each other's. Actually I'm looking to import data from a total of 5 workbooks and approx more than 30 sheets. If there is a way to connect with you I can explain the requirement in more detail
when i cllick on data it shows from access, from web, from text, from other sources but does not show from file or from excel..
sir then its better convert your sheet in tabular form and then pull it back to power query
I want to import multiple excel workbooks to separate sheets. how can I do that?
thanks a lot for your efford but have a question for another case related to that one. So I have that Sales Data file which we pull the datas to the other sheet in the video,ok. But lets say I also have another file which I just only have SOME of those item's name in it, not all of them. Imagine, I only want to pull quantity and price colum of those Items that I have in my file .How can we do that? I hope you would record a video of that case too or guide me . Thanks.
I cannot save the Source data.. saying its a share violation. help please.
Same thing for me. Checked google and followed their recommendations but nothing works,
Can we import only selected columns
It is not working for more than 1000 rows, what formula we can apply for more than 10k rows?
Is there a way to do this on a Mac?
how can i get a single value from a cell without transfering the "collumn" to the second spreadsheet?
Hi Brother thank you for sharing valuable knowledge. Recently I followed your channel I need one help bro regarding power query excel pls help this case
Hi sir,
Middle of the blank row of power Query.
please reply
How to do it in excel 2010??
Please reply sir
Hello very useful info.. I will buy you coffee.. Can you let me know how we can import only specific columns into another sheet specific columns,. eg. from Sheet1 I want columns C-E to be import in Sheet 2 column F-H
How to load data from a sheet consisting two different tables?
Can totals only be transferred to another sheet ?
Thank you sir.
Sir, please provide the workbooks for practice also. Thanks 🙏
They are provided. There is a link to the downloads in the video description above.
How to load a power query on an existing workbook?
Hi sir. Let's say, I have to add additional column (Ex. Status) as text. Whenever there is a change to the source like insert new rows in the middle or at the end, it shift the status that make record is not correct. Can you suggest the approach to fix it?
Thanks
Just wondering why % data type was not taken after you load the query, thanks!
Hi Sir, Thank you for your efforts. One issue I saw is when you changed the data type as percentage, in excel it was still shown as decimal. Is that normal?
Another issue is my system date is DDMMYYYY format but while pulling data from text, I saw the format changed to MMDDYYYY. How to resolve it sir?
Is your channel name a reference to Excel for Dummies, as in Trump = a dummy? Or just a reference to the general meaning of to trump?
Thank you sir
I have alternative blank rows I'm not able to import entire data. Power query import only upto 3 rows
Can you please make some videos on how to import data from pdf and multiple tables in pdf.
Pleaseeeeeeeeeeeeeeeeeee
How to do that with macOS?
How to fetch data from Google sheet using Power Query?