Power Query : Formula Method | Combine Excel Worksheets in a Workbook using Power Query Formula

[@Raj-e1b3r]

thank u veryyyy much sir .... dil se ❤❤

[@shrikantbadge3978]

Wow. Great Sir. Ab lag raha hai k जमाने के साथ मै चल रहा हुं. क्यू की if u don't learn, ek din uthake company kab degi pata hi nahi चलेगा.

[@Innozant]

Thanks Srikant ji..Jamane ke saath chalana hi hoga .

[@Msoffice-r3q]

Sir,you teach in very simple way everything is crystal clear

[@Innozant]

Keep learning 👍

[@durgeshgupta9532]

Abhi previous power query ki video dekhkar practice kari thi or next video ka wait kar rha tha...
Aur aapne upload bhi kar di...😂🙏
Thnx sir...🙏

[@Innozant]

Thanks Durgesh ji.. happy learning

[@mjaved701]

Amazing, always waiting your lecture on power query. May GOD bless you Ameen

[@Innozant]

Thanks Javed sahab

[@jawadahmadehssan6251]

Thanks alot, my data was multiplying itself after every refresh. I was looking for an answer the whole day and thankfully I come across your video and you explained it in 10 minutes. Thank you so much.

[@Innozant]

Thanks Jawad Ahmad sahab😂
Happy learning dear

[@MDRussel-b5y]

Thank you so much sir, Best online teacher in my life.

[@Innozant]

Thanks

[@aqeelahmadengr3]

Teaching style very good.

[@Innozant]

thanks Aqeel sahab

[@abhinav10x]

Great, A big thank you to you for sharing this valuable lesson.

[@Innozant]

My pleasure!

[@sandeepaswal8944]

Sir Your videos are very good and your explanation is easy understand.

[@Innozant]

Thanks Sandeep Ji . happy Learning dear

[@ArmaanKing17]

Amazing formula method! Thanks Sir

[@jayantabhattacharyya628]

Dear Sir
Awesome superb tutorial. Today's topic is entirely new to me. I have learned a new way of Append data through formula. Hope you will upload function/formula related tutorial in power query series.
Thanks & Regards
Jayanta Bhattacharyya

[@Innozant]

Thanks Jayanta,Hope you like and learn something new.

[@siddharthsatbhadre]

GREAT explanation... awesome awesome awesome awesome 🙏🙏🙏👏👏👏👏👏thank you SIR.

[@Innozant]

Thanks Siddharth Ji❤️❤️

[@kashifqasim8069]

great way of teaching new tihings

[@Innozant]

Thanks dear

[@prtkverma]

agar kuch columns mei alpha numeric data hai (for e.g. AX1004, EMP1002) to usme konsa Data type select karenge ?

[@asmrindia]

Text Data Type Lena Hoga...

[@surendrarajput731]

Very Helpful
And Nice 👍👍

[@vijaysahal4556]

Agar hum end equal -shift nabi kre to hum prewev main jakr extra sheet jsper data load krna h usi ko unchek kr skte hai but phle humko text filter not equal us sheet ka naam aise kr skte h sir ya nhi plz btaye 👍🏻👍🏻👍🏻👍🏻

[@satishojha6240]

Very easy and mostly useful thanku sir

[@Innozant]

Thanks Satish ji

[@sanjayTECH04]

You are a genious, sharpness is your right

[@Innozant]

Thanks Sanjay ji.Really means a lot to me

[@krnrajan]

Thank you so much for such wonderful tutorials. So nicely explained. God bless! One query. Where do I get to read more information on Excel.CurrentWorkbook() and similar formulas

[@Md.Ismail-v1e]

Good Night Sir,
Wonderfully.

[@syedtahirbukhari8377]

Nice really make Full one like this

[@rakeshmlearningentertainme6099]

nice all video and learn lots of thanks you sir jee

[@vijaykumarjain3222]

Nice sir which video for inconsistent column in two worksheets for merging in one sheet through power quarry,and also renaming of header while marge

[@devendrakumarsharma8809]

Excellent learning.
Could you plz advise how to merge data from separate sheets exists in a single folder

[@Innozant]

Soon you may able to watch this video.

[@vijaykumarjain3222]

Nice sir , how to merge inconsistent coloum of different worksheet in one sheet and rename of colum

[@PragneshPatel-pv7mo]

Sir, 1 master workbook me data hai aur usme last 2 column blanks hai to vo data different sheets me 2 column ka data hai to use merge kaise kre?

[@kiituniversity115]

Sir app kona mic use krte h?

[@kishorpanara4191]

Maan gaye sir aapko thanks sir naya SHIKHA ne ke liye

[@Innozant]

Thanks Kishor

[@hafiznaseer1988]

Great Sir

[@TheSuvankarKundu]

So much appreciated.. 😍😍

[@Innozant]

Thanks Suvankar ji

[@asmrindia]

Sir Thanks and Very Nice Explanation 👍
Lekin Ek Baat Bataiye Ki Jab Refresh Karne Par 5th Sheet Query2 ka data Usme Append Ho Raha Tha, Tab Aapne Direct Simple Filter Karke Query2 Ko Unselect Kyu Nahi Kiya. Aisa Karne Par Bhi To Remaining 4 Sheets ka Data hi Load Hota???
Please Bataiye
Thanks

[@Innozant]

Humen load nhi Krna tha sirf connection establish Krna tha that's why

[@asmrindia]

@@Innozant Ok Sir, You are a Nice Mentor. Thanks, Om Sai Ram😀

[@mohammadaijaz4901]

Good job Sir, very well...

[@Innozant]

Thanks Aijaz

[@mohammadaijaz4901]

@@Innozant Sir aap se yeh poochna tah k maine ek table power query main load kiya or uska link banaliya ab mein ye link dosri workbook main use karna chata hoon kaise karen ge sir

[@mayyuchape7195]

Very Empracive 👍

[@Innozant]

thanks dear

[@VipulJain40]

Dhanywad Guruji

[@saurabh17sharma68]

Awesome Awesome Awesome sir

[@Innozant]

Thanks dear..

[@horrorlovestories]

Sir maine sheet macro enable workbook kiya save as karke , but jab maine normal excel file mein close and load kiya toh error aa raha tha. Sir aisa kyu hota hai file type mein?

[@kabirvachanupdater7072]

Jha hmara sare step show hote hai "Query setting" usko agr hm cut krke hta de to vo vapas kha se aayega .
Reply sir

[@jhamran9680]

Thank You Sir ❤️

[@saitinudesai]

Superb

[@meditationmusic6482]

So nice Sir ji

[@Innozant]

Thanks 🙏❤️

[@vvv1160]

But why it's not coming

[@ajay306]

What difference between append and merge

[@Innozant]

Kindly proceed with more videos of power query

[@ibrahimkvlogs3220]

Sir Mis ki job bataye kahi delhi ncr me I'm fresher plz

[@Innozant]

Ok.. assessment test lete hain uske base par ref provide karayenge

[@Harish.Prasad.Semwal]

0:46 2:31 4:06 7:28

[@rasimrajashaikh2815]

Thank u sir

[@Innozant]

Thanks

[@hsgusain2054]

thnak sir

[@sonukumar-xp5sd]

Nice

[@kumkumchakraborty2892]

sir sql please

[@ubaidillahmuhammad20]

bravo

[@Innozant]

Thanks

[@kirandodke3647]

master strock sir

[@Innozant]

Thanks Kiran

[@sadashivkage3133]

🙏🙏

[@gauravbhatia7987]

🙏🙏🙏

[@Innozant]

🙏❤️

[@imranali-iy5wk]

Aj pata chla k rows add q hoti te

[@Innozant]

Kyu?

[@imranali-iy5wk]

@@Innozant kun ka sir dhonda bht youtube pr answer ni mila eska aj mila aur logic ka bhi aj he pata chala ka back pr naya table add ho jata ta jiski wja sy rows barh jati te Thanks alot

[@nileshchavan742]

👍