How to merge data in Excel? || Combine Multiple sheets in Excel using Power Query
HTML-код
- Опубликовано: 7 июн 2020
- How to merge data in Excel? || Combine Multiple sheets in Excel using Power Query ...This very is for all excel operator those who are looking to become expert in excel then they must go with this video, here I have explain how we can merge data dynamically from different sheets of excel, this excel tips will work in Excel 2010, Excel 2013, Excel 2016 and excel 2019, This is the excel tutorial on Power query in Hindi
Attend Satish sir's Online Webinar Free: courses.skillcourse.in/webinars/
#ExcelPowerQuery
#ExcelTutorial
#LearnMore
Download Practice File :
learnmoreindia.in/combine-mul...
------------------------------------------------------------------------------------------------------------------------------
Learn Satish Sir courses with Certificate
Download Course App : bit.ly/3BWfQVa
Courses Website :bit.ly/skill_course
Course Features :
✅ सभी Videos सरल हिंदी भाषा में
⬇️ Download Video in APP
✅ Basic to Advance Courses
✅ Practice Files (Yes)
✅ PDF Shortcuts
✅ Course Completion Certificate
✅ Instant Access
✅ Watch on Desktop : skillcourse.in/
------------------------------------------------------------------------------------------------------------------------------
To download the practice file visit our telegram channel: telegram.me/learnmoreindia
Check our latest blogs: learnmoreindia.in/
------------------------------------------------------------------------------------------------------------------------------
Social media Pages:
Facebook Page Link: bit.ly/3CvGlBT
Instagram Page Link: bit.ly/3f9R37u
------------------------------------------------------------------------------------------------------------------------------
My Other Channels:
Real Tutorial: ✅
/ @realtutorial550
Complete Technology:✅
/ @completetechnology
Learn more shorts:✅
/ @learnmoreshorts
Satish Tech (Marathi):✅
/ @satish_tech
Tally Tutorial:✅
/ @tallytutorial
Exce Tutorial:✅
/ @excel_tutorial
Learn More:✅
/ @learn_more
Curiosity: ✅
/ @curiosity9432
------------------------------------------------------------------------------------------------------------------------------
My RUclips Gears :
Best Mic for Recording (Condensor Mic): amzn.to/2UUMDnH
Best Mic for Recording (Dynamic Mic ): amzn.to/3pQgyvD
My DSLR Camera Canon 200D: amzn.to/39ciw3E
My Laptop (Video Editing): amzn.to/2UXQj8h
Laptop (Office Use/ Home use / Budget Laptop) : amzn.to/3l0pniw
Antivirus: amzn.to/3l3TIgi
Screen Recording Software: bit.ly/2J39n2j
Video Editing Software: bit.ly/3nOPlri
Green screen with Stand: amzn.to/2KAl1Cu
Tags : How to merge data in Excel,excel tutorial,combine data in excel,excel tips,excel tutorial in hindi,excel powerquery,power query in excel,Power query tutorial hindi,excel tips and tricks 2020,excel tutorial 2020,excel in hindi,Microsoft excel,excel by learn more,excel tips 2020,Merge sheets excel,Power Query Tutorials in Excel
Attend Satish sir's Online Webinar Free: courses.skillcourse.in/webinars/
ही
Learn More is my real motivation for making videos, so plzz can anyone tell me my videos are good or bad🙏🙏🙏😥😥😥❤❤❤ 🔥🔥🔥
Good
@@black_shark1480 Thanks Bro
What ever I got in ms Word, excel and PowerPoint from this that is so beneficial Thanks sir
Sir, teacher or bhi h RUclips p .
App sb se alg ho.
I Love your way of teaching.
Maan gaye guru ..Kamal kaa video hai..
Dear brother , your all videos are best than others, thanks for sharing your knowledge with us. i want ot request you to make an automatic FiFo inventory management system for items having more than one barcodes, from purchase to sale and net stock, having automatic data links and reports in charts. it will be a great favour from your side to all of us.
God bless you, thanks
Sir,
Your teaching style is unique.🤗👍👌
It's was very easy and simple 🙂
You awesome 👏 sir , thanks
I'll definitely need this in my near future.
thanks
Thank you so much Sir for this wonderful session with best explanation 🙏🙏🙏🙏🙏
Thank you so much sir. Really very Nice videos sir🙏
I downloaded the excel file and tried practicing the same. But when I did power query for Sheet 1 it shows Table 1 on Power Query Editor at the right hand side. In your case it is showing Table 1.
For sheet 2 = Table 2, sheet 3 = Table 4.
So, when I did as per your instructions the error message at the end shows that "Source Table 1 available".
Then I changed it to 2,3 and 4 bcoz sheet 1 represented table 2 in my case, all good.
Why was it showing so I do not know why. If you have any answers please let me know.
Thank you.
great content and amazing.. salam creator excel from indonesia
Satish sir u are amazing person..
Wow, it's working 😍, my problem has been solved.
thank you so much...Sir
Really% you are hero ...for learner
Most important topic thank you sir hame batane ke liye it's use
Aur thank sir ye video upload Karne ke liye ye video buht hi aacha tha
Thank you so much , sir 🙏
Superb.this is actually what i want
What if the data is different in few sheets? Like if in one of the month there is entry of two or three new employees, then what?
Will powerquery handle this or different steps required in this?
Thank You Sir
Your Explanation is very nice and easy. Sir please Power Query in HR से reletated video भी बनाईए
very good idea sir become expert in excell
Thank you sir your every video is very important for all students.
ruclips.net/channel/UCUWcyY2oZerHZg2WKCEzFCA
well done guru ji
Thanks Sir ji🙏
sir could i know that tthe different between conslidate data and data merge becaz both work same
Can you pls help me to know what denominations of cash to be disbursed for petty cash against the available denominations.
U R THE BEST TEACHER
I have a question i have data with me and according to that data how can i sort data available in different sheet and in its different columns?
Kuch hat ke hi karte he aap. Isliye aapke vedio ache lagte he. Useful information ke liye thx. 🙏
Hlw sir this knowledge really helped me but i m facing problem in power quary.
The problem is when ever I add more tables in it. It shows (expression error. We couldn't find table named .) What it and solution????
Very nice video sir ji 🙏🙏👍🌹
Sir VBA or Micro ka upper ek complete video banao sir...
I really like you video and the way of explaining
Sir excel k saath digital. weighing scale jassa external input device kasa connect kar sakte hai.. please bataiyaa ga ☺️🙏
Great content, Thanks
Very important update formula sir
Its helpfull, do more trick in excel
Great working..... trick
Nice video bhai
Thanks sir. Your all videos is very helpful for every computer 🖥 user 👤 🙏 🙏
Very good explanation
Good evening sir my question is i have multiple files and different locations in data but i want to merge in one excel sheet ????¿
Hi Brother, I have 15 columns and 5000 Rows in my every 5 sheets. So i am unable to combine multiple sheets in excel using Power query. error showing "the data in the preview has been truncated due to size limits. reducing the number columns or filtering may load more data." Kindly help
Nice Video Sir Keep It Up Sir @ Satish Dhawale Learn More 👍👍👍
Sir job pe bhi ek video banao ki kis company mai apply krna best rahega growthf company ho
Hello sir ek new topic par video banaye like Networking , command prompt , HTML , C++ and Java etc
thanks sirjee...
Sir ..muje ek query hai ..muje baar baar concatenate ka formula use karna padta hai jisme around 15 sell ka data ek saath me lana hota hai ..is there any fast alternative way to do it .. without concatenate .. please reply... thank you
Thank you sir 👍
Thank you sir 🌹
Sir Adobe InDesign ke upar full tutorial dalo plzzzzz....
Can we combine data horizontally by power query?
Satish sir agar alag alag excel workbook ko ek workbook me merz karna ho toh kaise kare
Hello Sir,
We have a folder in which we have 150 no. of excel files & all these files data is being stored in a different master file using get data from folder option.
Each time when we are changing the data in these files same thing is updating in master file. It is simply over writing the same. Is there any option so that we can add on the change instead of overwriting.
How to ready Complaint managment sheet sir? Pls make a video on this topic.
Sir plzz Help me
Mere PC me MS Word ka Product Key mang rha hai...
My kya karuuuu..
Replyyyy
Sir what is Expression Error: we could,nt find an Excel table named table1
Sir muje excel me ak shit me alag alag name se alag alag data h un sab me ak sheet se sab me company ka data dalna padta h ho menual kerna padta h asa ho sakta h Kya k ak sheet se dusre sheet me uske name Ke hisab se data Marge ho jaye
Sir
Agat hum is trah se workbooks mege kerte hai un ki ik work sheet mein combine kerte hain. In future hum kuch change kerte hain ya data enter kerte hai kisi bhi workbook mein to jo combine sheet hai us mein automatically change hoga. Agar koi aur tareeka ho to wo bhe bataye.
Very nice 👌😊
Sir Word ki formatting ke bare me batayi kese header and footer me page no + company name + other thing kese insert ke saat.
very awesome video
Sir, excel file ko tally mai convert ki ja sakta hai kya ?
Thank you so much sir
Satish Sir Charts & Graph par video nahi hai kya aapka
Sir youa are super
THANKU SIR VERY MUCH
Bhai, agr sheet 1 pe Raw data and I want ke sheet 2 pe ek dashboard ban jaye graphical representation ho,, mein chahta hun 1 click mein auto report generate hojaye 1 clik mein
Thank you so much
Kya mai ek file pay vlookup lagane k baad duseri sheet pay kam kar sakta hu jab first file mai vlookup render ho rha hai
Sir error mil rha hai after running the PowerQuery installation wizard "Internet Explorer RTM 9 or later is required". Please advise/guide
sir plz INTERNET DOWNLOAD MANEGER ko regester kesy karen usky bary men thorhe guaidness deejeaga
hello sir
what about SAP FICO from your channel??
Sir aj to chai pi k hi jana h... hehe... very ice video
Abhari aahe rao tumchi comment lai bhari aahe rao
@@Learn_More_Pro tumchya shikvnyachi padhat khop awdte... keep it up.. tumhala prtykshat bhetayla nakki awdel... truely admire you..
When I open an excel sheet
Excel sheet of many other names opens, so what is the solution?
Very nice.
Aoa. Sir micro soft 2016 ma end load nhn hota data errors atta ha
"Load to data model failed."
Plz advice
Sir me javi try karta hun toh syntax error ata he like - token equal exoected
Thank u
Revit architecture pr ek full video banao sir
Append queries per option sirf ek table kaa hi dekha raha hai sir, 2016 Excel per . Please help
good job sir
Expression.SyntaxError: Token Equal expected. sir please help this error.
Different excel files ho or use 1 file me merge krna hai tb kse hoga??
Sir for window 7 mein kya karna hai merge karne ke liye
Sir agar new sheet ki jagha new work book par hume tablr Marge krke upload Krna ho to kese kare
I GET ERROR WHILE MERGING SHEETS IN EXCEL 2016 AS DATABASE EXTENSION ERROR . PLEASE HELP HOW TO SOLVE IT.
Very power ful
STILL NOT HAPPENING POWER QUERY ADVANCE EDITOR , HOW CAN I CONSOLIDATE ALL SHEET IN POWER QUERY EDITOR
Goodmorning sir
Thank you
Excel per marksheet kaise banaen es ka video bns do plz sir ❤️🙏
Good evening sir sir aapne ms word ka pura tutorial banaya hai sem vaise hi ms Excel ka bhi video banaao na sir please mere liye bahut important hai sir
Sir make video on v look-up formula
sir ye 2007 me chal jayega kya
nice video
Sir is sheet ne ek doubt hai, example theeno sheet me same date hai, par data alag alag, last me result me automatically date wise data sort hoke show hona chahiye.
Warna ye to simple copy paste ke barabar hai
Amazing
sir agar exel sheet 3 4 ho or vhi sari sheeto me kaam ak hi kiya ho data same he lekin charo sheet me aadhe aadhe data he to fir un charo sheet ko milake master sheer yani sab data merge kaise kre plz uska vdo bnaye
plse give videos for all features of insert excel and data tab