Dear Sir This is a very useful tutorial in power query. It helps me to familiar with the different tips & tricks in power query. Of course I will be able to learn power query more efficiently under your guidance. Thanks & Regards Jayanta Bhattacharyya
Sir. I had subscribed you. I thing I would like to ask from you please let us to know your subscribers about tat why and when we should use advance filter and when use auto filter . Major differences between both. Thanks and Regards.
We use autofilter when small set of criteria but it's complex when we have set of conditions or crietria. Autofilter feature filter the list in place but if we want to Extract data ij another location,another sheet ,Advanced filter is good.
Sir. Thanks for reply of my query. I like very much your tutorial it is very useful for the public. Stay Bless. I thing I would ask by you kindly differentiate between work day function and week day function there is a little confusion about using of function . I will thankful to u. Regards.
sir 1 doubt hy....merged cells content ko unmerged cell me kisa copy karte hy...o b consequtive cells me(example me 2 cells ko 1 cell me merge kiya i8,i10,i12 in me meine bara 2,3,4...iski baaju wala column me j8,j9,j10 me ye 2,3,4 kisa lana h?)
When I copy my query and change source, all the steps are followed but data total is incorrect , when I follow all the steps manually, data total is correct, how do I check what is going on with copy query? Pls advise sir
Sir apka ek video tha sequance function jisme data row me repet data ko colume me transpose kiye the please woh video nahi mil raha hai mujhe woh link chahiye. Kyunki mere office me need ho rahi hai report banane ke liye.
@@Innozant 1 Ram 500 2 Sita 300 3 Gita 600 Is data ko 1 Ram 500 2 Sita 300 3 Gita 600 is tarah se banana hai mere pass bahut bada data hai. Apke 365 list check kiye mil nahi raha hai sir please help me.