consolidate multiple worksheet into one pivot table | How to combine multiple worksheet into one

[@vipuldevrani]

सर आपसे बढ़िया सिखाने वाला ट्रेनर मैंने आज तक नहीं देखा अपने 10 वर्षों में जिस ईमानदारी से आप बिना फीस लिए किसी से भी सब कुछ सीखा देते हैं वो अतुलनीय है आपकी जितनी भी प्रशंशा की जाए कम है आपसे सीखकर ही मैंने एक्सेल में बहुत आएगी बढ़ पाया हूँ आपको बहुत बहुत धन्यवाद : विपुल

[@AbdulKarim-ms1xb]

THANK YOU SON I AM FROM KARACHI PAKISTAN, AND I AM ABOUT 65 YEARS OF AGE BUT I REALLY ENJOYED YOUR LEARNING AND ALSO PREPARED A SEPARATE PIVOT TABLE MYSELF SUCCESSFULLY AND PREY FOR YOUR SUCCESS IN THE FUTURE I REALLY LIKE YOU

[@Innozant]

Thanks ..Really means a lot to me..Keep learning

[@darshangohil222]

Apke jaisa Guru mil jaye to life ban Jay .Thank you Sir..

[@Innozant]

Thanks .Keep learning

[@gusaisingh4802]

Ur video always simple Nd deep explain yehi chiz aapko oro se alg bnati h thnku

[@sandeepaswal8944]

Dear Teacher I am really grateful for your work. Thank you very much, this will save me a lot of time. These videos are probably the best training videos. You are my favorite excel teacher.

[@Innozant]

Thanks Sandeep Ji for such a valuable feedback.Have a great day ahead

[@atulshukal4072]

बहोत बढीया वर्क नया देकर खुशी पाता हे धन्यवाद साहेब

[@Innozant]

Thanks Atul ji

[@Altaf_Alam]

Sir Your all the contents are very helpful for me😊.....these contents are perhaps available on youtube ❤️🙏

[@Innozant]

Thanks dear

[@vsrjob]

Outstanding style of teaching 🌹🌹🌹🙏🏼👌

[@Innozant]

Thanks ..Keep Learning

[@swapnilpawar708]

I don't have word for appriciate your talent dilip sirji awesome thank you for teach me that forever 🙏

[@Innozant]

Thanks Swapnil.. Really means a lot

[@manjunathagangaiah6755]

I was struggling to extract data from multiple work sheets but this is the very easiest method. Your way of explanation is awesome. Thank you.

[@Innozant]

Thanks

[@saadchaudhry9110]

thanks a lot, from pakistan...keep it up bro. i was stuck and now problem solved

[@Innozant]

Thanks dear 👍❤️

[@devendergusain8974]

thnkx u verymuch sir ji watching all your videos from past15 days....

[@Innozant]

Thanks Devender Ji..Happy Learning

[@pramodbhavsar4488]

Very nice pivote table with multiple sheet and consolidate amounts in excel awsame idea thank you sir

[@Innozant]

Thanks Pramod Ji..Advance Pivot video coming soon..

[@real5731]

Best thing about your videos is that they are practical.... Not just showing what a perticular command..... Appreciate your efforts in not just creating example data but also explaining them 👏

[@Innozant]

Thanks dear...God bless you..Happy learning

[@saurabh17sharma68]

Mere prabhu aapko koti koti pranam🙏🙏🙏🙏🙏🙏🙏🙏

[@Innozant]

Thanks Saurabh🙏❤️🙂

[@UsmanGhani-vf3ow]

Thank you very much, I am glad to seeing you're easy, knowledgeable,beautiful, relax and comfortable videos and create a confident inside me. Your way of teaching is superb and amazing

[@Innozant]

Thanks Usman..Keep Learning ❤️👍

[@hemendrakumarvarshney8825]

Excellent way of teaching with full of energy and a smiling face.. 👍🙏

[@Innozant]

Thanks Hemendra ji

[@swadealhadecooking5587]

Exactly Kuch na kuch new hota hai 😊🙏🏼

[@Innozant]

👍❤️

[@swadealhadecooking5587]

@@Innozant Thank u Sir 🙏

[@EARishiSteelTubes]

Perfect on to point..! no one can forget the way you teach skills sir..!

[@Innozant]

Thanks Rishi..Keep Learning and exploring

[@shubhamgupta392]

Amazing trick of consolidation data... ❤️

[@satishojha6240]

Wow sir amazing 😇😇 good night

[@Innozant]

Thanks Satish Ji,Practice jaroor karte rhiye.Regular.Good Night🙏♥️

[@sonuharipur]

Thank you so much.. very useful and effective

[@Innozant]

Thanks Sonu..

[@anupagarwal8347]

Amazingly simple the way you make it!!!!

[@Innozant]

Thanks 🙏❤️

[@imranahmedmirza7045]

Excellent video...you are genius

[@Innozant]

Thanks Imran..Happy learning

[@hemantgusain1260]

Great explanation sir

[@Innozant]

Thanks Hemant.🙏♥️🙂

[@sharmacreatives255]

Ur attitude is very beautiful sir 🥰

[@Innozant]

Thanks Sharmaji ♥️♥️

[@shivamsinghal6020]

Gazab ho Bhai Aap!!!!!

[@arvindtech408]

Thank you sir you are best teacher

[@artiverma2357]

GOD APKO OR APKEY PRIBAAR KO KHUS RAKHEY

[@Innozant]

Thanks Arti..Apka bhi humesha healthy brahen aur Professional life me bht aage jayen.❤️🙏

[@karthikeyanka]

Thanks 😊🙏 very useful 👍tips

[@Innozant]

Thanks ❤️🙏

[@shrikantbadge3978]

Today was the last date of annual return filing for FY18-19 and 90% excel work he handed to me, ignoring senior employees. Thanks to you Sir.

[@Innozant]

M really glad to hear this from you.God bless you dear... Learning Kabhi band nhi karna hai aur Aise hi life me aage badhte rahen yhi meri wish hogi humesha .👍❤️

[@Vikas_Bhalekar1989]

Superb sir ❤🎉

[@mohdhidayatullah9930]

Dear sir its very helpful

[@Innozant]

👍❤️

[@puransingh-sx2tk]

Majedar 🙏👌

[@Innozant]

Thanks dear..Good Night.tc🙏♥️🙂

[@AnkitSingh-mh7ee]

Hi sir I have a question, I need multiple grand totals in Excel.i need sum and count of a data simultaneously in Excel 2016 .

[@superNareshg]

Thank you sir for your wonderful learning

[@Innozant]

Thanks dear❤️

[@1gopalakrishnarao]

Excellent 🙏👍

[@Innozant]

Thanks Sir.🙏♥️🙂

[@shrikantbadge3978]

Apke videos dekh dekh ke sir me itna sikh gaya ki ab manager bhi aata hai queries puchhne ya fir muze bulake dhimi aawaj me puuchta hai how to do this and that...:))

[@Innozant]

Sir usko bolo puchne mat ao aur agar aa bhi rahe ho toh Zara salary bhi to badhao😅ab benefits bhi uthao agar mil rahe hai Thanks Shrikant thanks a lot for this valuable comment

[@thangaveluraj5366]

As usual, excellent

[@Innozant]

Thanks dear

[@hemendrakumarvarshney8825]

Superb.. 👏👏

[@harsha7677]

Thank you for sharing video. It helped us alot. Here we have one similar coloum in all worksheets. If we have two or more similar coloums in all worksheets, how to make one pivot.

[@praveshkumarroy2327]

Thank you so much sir

[@untilanurag2178]

So data should be in same format to do this ?

[@Innozant]

Yes

[@mosadiq123]

Very good information

[@Innozant]

Thanks ❤️🙏

[@dnyaneshwarudhare1074]

Great sir....👏

[@Innozant]

Thanks.God bless you dear

[@prajwalshetty2047]

Nice Video 👍

[@Innozant]

Thanks Prajwal

[@prajwalshetty2047]

@@Innozant Sir I used separate Power query to append Gross sales of various Branches to find total Gross sales and Sales return of various Branches to find total sales return in two different sheet, in one sheet total Gross sales and in other sheet total sales return. To find Total Net sales, I manually reduce sales return from gross sales. Sir is there any way to do this all calculation in power query itself.

[@arunssairam]

Superb Sir

[@artiverma2357]

U R MY FEVOURITE ONE

[@Innozant]

Thanks dear..No Words.m❤️❤️❤️❤️❤️🙏🙏

[@curious1245]

Sir I am facing pivot overlapping message on refreshing all pivot table. Even I have only one pivot table on one sheet. How to resolve this. Pls advise.🙏

[@learningNewIdea]

Mai apke video se bahot kuchh sikha hai aur sikh raha hun , sir please mera online interview llijiye na 🙏

[@Innozant]

Aaap proquest series attempt kijiye..online interview mujhe dene se better try kijiye opening ka..apni skills ka pata chalega aur improvement kya karna hai wo bhi

[@prahalladjena1634]

very nice. How to calculate two different sheets in and out items in a single pivot table in MS Office and Google sheets. please suggest

[@sarthakbhagu707]

Nice sirji great

[@Innozant]

Thanks Sarthak..Good Morning.🙏♥️🙂

[@mohammadarsh1492]

Excellent Sir👌 Par Sir Aapne 2 ways batae. Dono ways me Source Data to same hai par dono ke Pivot table me alag alag Sum aur Grand Total kyu show ho rha hai. Please help sir😢

[@krishnaaryan2903]

Amazing sir

[@PaulieVlogs]

Amazing !!

[@SinghSurinder16]

Superb sir ji

[@Innozant]

Thanks Surinder Ji❤️🙏

[@mkshorts8235]

Sir I have a question i am not getting creating pivot table in power query load to option directly in office 2016 version is there any solution?

[@zzzzz644]

Like at 01:55 in video. That shortcut key for pivot wizard doesn't work in excel 2019. what should i do??

[@Nsatywali]

Nice one

[@Innozant]

Thanks Naveen ji

[@tanmayvt28]

Suppose If there are around 20 column headers in one sheet and in the 2nd and 3rd sheet there are 10 column headers, then will this work?

[@aritramarketing1491]

I tried it but didn't work

[@ramdanech7215]

दुसरे वर्कबुक से डेटा पीवट टेबल पे ले सकते है क्या..... सर ?

[@bhargavtalreja5480]

Ismien Sir agar koi cheeze "SUM" ki jagah "COUNT" leni ho ya koi aur function lena ho specific column title(parameter) k liye to kaise change karein?

[@Pradeepyadav-fj1dp]

same Google sheet mai kar sakate hai kya ???

[@Innozant]

Why not

[@g2sagar]

Wow nice Sir.

[@Innozant]

Thanks Gangasagar

[@kinghundred]

very useful sir

[@ritenderchauhan3846]

Hello - I am using excel 2016 standard version, which doesn't have a power pivot, how can I create a pivot table from two tables having duplicate values in each table, I cannot create a relationship as that would require unique values in at least one table.

[@achyutsingh]

how to do the reverse : split data as per region is different sheets

[@RamSingh-ol5xz]

Excellent sir

[@Innozant]

Thanks Ram..🙏♥️🙂

[@excelmaster1328]

Sir like i have 2 data of north and south but in 2 data it include 2 rows State and product Ab pivot me meh chaata hu dono rows me aaye But comsolidate vala method se kaise laaye ?

[@gauravbhatia7987]

Sir je keya purane pivot mein hi kar sakte hai multiple sheet ka da join ja jo 2007 mein waha bhi kar sakte hai

[@Innozant]

Haan Kyu nhi Kar skte Hain

[@DimpleSharma-p9x]

Thank you

[@GaganArora090]

Sir agar yahan data dynamic ho toh tab kya karein...PLZZ breif...do we need to convert data into table?

[@Innozant]

Dynamic ho means ya to wo table Hoga to use bhi table me convert ya wahan dynamii formula ke through Kiya Hoga to offset se data pull hone ke baad bna lenge dynamic ise bhi

[@GaganArora090]

@@Innozant sir I tried to do that by converting the raw data into table but pivot table not getting change...

[@Innozant]

Why it's change automatically..we need the make pivot dynamic na

[@rounakprasad1852]

If someone updates some data in any of the workbook then will it get updated in pivot table .

[@MegaPawan420]

Mere pass 9 lakh ke 3 sheet hai Kya ek hi pivot table bana sakta hu 1 lakh se kam cells hoti hai to ek pivot ban jati hai 9 lakh pe nahi

[@forgotten_friend5406]

nice method

[@rekha3280]

while using consolidate pivot, I am not getting all columns name. please avice, how can i get all column names

[@ganeshdate4186]

Sir same proceed kiya lekin only value and raw aaraha he

[@harshahire4890]

Thank you Sir

[@watamote8694]

Can it work on excel 7

[@swapniladamapure6115]

How can edit the pivot after reporting?

[@sajansuresh60]

How to remove the grand total in this pivot table

[@bishtlokesh1297]

Wah very nice😀

[@Innozant]

Thanks🙏🙂

[@shaileshkumar-qf6bd]

shukriya guru ji

[@arpitasaha7854]

Sir, how to incorporate countif in pivot table?

[@rahulrakshe1988]

Nice teached

[@Innozant]

Thanks dear❤️❤️

[@hiteshchourey9730]

Best video

[@rawata185]

I love you sir

[@sawaimalhi8439]

dear alt+d+p krne k baad data add tu ho gya par jab new files sheet pa jo data ana chaye wo nhe aya pata nhe q ...phir mainualy data ko pivot table arrange kra main meri pass ms office 2019 version hai

[@Innozant]

manually kyu..ofc 19 me to koi issue nhi aata h

[@sawaimalhi8439]

@@Innozant thanks sir

[@anubhav19888]

Bonus is best tip

[@udaichahar1735]

Thanks sir

[@gkvenkatachalam2476]

Hello ji ..I have a problem.i have data where column headers are dates.so how to group them in pivot table..not getting options

[@Innozant]

Didnt Get your query..If column headers aee date then we are able to group on that ?Where you are facing issues.

[@gkvenkatachalam2476]

@@Innozant can I send you picture on number

[@Innozant]

yes ypu mah send screenshot

[@mayanksharma-kw8xo]

THANKS

[@akashgarg1962]

New excel me kya h shortcut, please btao

[@AmanBhargava-tt7id]

Awesome

[@adnanshoukat807]

sir plz aik final test b hmra ly ln. ap sy jo sekha sara revise ho jaye ga.

[@Innozant]

Adnan Sahab..Abhi bht kuch seekhna hai.Aur bht Jald New Playkist Launch hone wala hai..SkillTest Series....

[@adnanshoukat807]

@@Innozant ok sir intazar rhy ga.

[@rahulrakshe1988]

Nice sir

[@g2sagar]

Sir, I want to ask one thing that what is limitations of pivot table??

[@Innozant]

will share some drawback list in upcomjng videos ..

[@adnanshoukat807]

hamesha ki tarhn best

[@Innozant]

Thanks Adnan..Love you all.🙏♥️🙂

[@kavita8390]

Very informative video. Sir, I have a query, I have total 3 columns , 1- country, 2- products and 3- sales when I select entire data to consolidate , product column appears as values instead of product names. How to fix this, pls advise

[@Innozant]

Thanks Kavita,Kindly share your query @innozantofficial telegram id

[@kavita8390]

Hi Sir, I have now sent my query via telegram. Thanks Kavita

[@faheemtanoli2203]

@@kavita8390 plz share answer with me, i have same query

[@himanshuparmar1964]

WHAT TO DO FOR CONSOLIDATING MULTIPLE WORKSHEET DYANMICALLY ?