Combine Data from Multiple Sheets in a Single Sheet

[@cautiouspanda3570]

Chanddep, I just consolidated a massive file that was related to a 100 Million dollar project! Kudos brother!!

[@GoodlyChandeep]

Hope you get a percentage of that 😅 Cheers

[@cautiouspanda3570]

@@GoodlyChandeep thanks unlikely haha. Thanks brother

[@NivyaSG]

@@GoodlyChandeep heyy, I unable to get your video on consolidate the data from different files when data is not in identical format ie. Columns are different. Can you please help on this.. appreciate your quick turnaround

[@GoodlyChandeep]

Check out our newly launched M Language course ↗ - goodly.co.in/learn-m-powerquery/

[@ameliajacobs2549]

THANK YOU! MY FIRST TIME CONSOLIDATING MY FILE INTO ONE WORKBOOK. THANK YOU A LOT!

[@srinitnt]

Absolutely brilliant..! Thank you so much..! I never knew this and just applied to combine data from 167 sheets and it worked like butter smooth. Thanks a Ton..!

[@GoodlyChandeep]

Fantastic!

[@CatWhite]

Chandeep, this was fantastic. You clearly explained processes that others simply glossed over and I was able to complete an important project. Thank you!

[@IrfanKhan-qm8qc]

Glad to check this video, Found what i was looking for. Thanks Brother !

[@mytablon]

Thanks. Watched many other videos. Your solution is simpler & quicker. That works. Thanks!

[@GoodlyChandeep]

Small world! I am also based in Dubai and have seen your events on Meetup. Would love to join someday. Cheers

[@mytablon]

Hi Goodly. I amazed how did you notice it. You are very welcome. Write me anytime [e-mail]

[@onidbibo9833]

Your method is much easier to understand & it helps me to consolidate all my data into one workbook.Thanks for posting this video.

[@BobROBERTS-xo7eo]

I have been searching for a way to do this, Thank YOU!

[@GoodlyChandeep]

Glad I could help!

[@arunkumar-be7li]

Very Useful and Perfect Explain that how to Consolidate the Whole sheet in single Source of Sheet.

[@rajasimhapuppala8068]

Hi , thanks for your information, can you please help me how can consolidate multiple excels to one excel, now what you showed is in same excel, but now i want defferent excels

[@arunmishraajm]

I love the way you explained .. Great job.

[@Michael-ym3xw]

Brilliant - thank you for sharing - saved me a ton of time!

[@leabalois4548]

😊 🎉 you always serve the best tutorial for complex function of power query. Thank youuu for your enthusiasm to share your knowledge!

[@GoodlyChandeep]

Thanks Lea!

[@donteadoss]

Incredible tutorial - thanks so much, definitely SUBSCRIBED!

[@nagautube1]

Thanks much for this knowledge share, appreciated!!

[@vanessayong5353]

Thank you for the guide. i do have some additional question on adding more sheets. you shown us to replicate sheet at (06:01) , would it still work when we Create New Sheet (+)?

[@vanessayong5353]

another thing, i tried working on the same Workbook (01:18) > Data > Get Data > From File > From Excel > "same Workbook" > Import , i get the following error msg "Unable to Connect: "The process cannot access the the file 'c:\Users\userA\Workbook.xlsx' because its is being used by another process" Would you know what this error means.?

[@mmincredible1451]

Bravo Chandeep🙏👏👍 love u...

[@HaPham-jg8nf]

Appreciated to your lesson! You save my life 🙂

[@robfrantz9907]

This is so helpful! Thank you so much!

[@fortunatelekhuleni1546]

Thank you so much.. perfectly explained!

[@ankitmehra7679]

Thank you so much man...Just love it

[@saurabhnathani7133]

Can we lit this consolidation to certain row, as i have totals in each columns end, and it is considering it too.

[@radheytakle]

bro thanks , it helps me a lot. easy to understand

[@cd_systems-u8s]

Thank you, this is very helpful!

[@suvratrai]

Thanks for making this video,, helped saved a lot of manual effort for me.

[@rashtech8539]

Thank you my bro Chandeep from Bangladesh

[@mariamakhondo9716]

Thanks so much. This was very helpful

[@shwetankansal]

Great explanation brother . Thanks a lot !👍

[@craftymehreen1847]

You are Genius !!! Awesome Chandeep Bhai

[@navsharma79]

chandep bro... thanks to help me to consolidated my large no. of files

[@ramonbaiges3193]

Wonderfull explanation. You speak very fast. I need to pause and rewind. Lots of information. Thanks!

[@GoodlyChandeep]

Glad it was helpful!

[@seesumisu]

awesome video! thanks...saved me so much time!

[@GoodlyChandeep]

Great to hear!

[@shyjuks975]

Bro please let me know which course help you to learn the advanced excel or pro

[@easycooking9480]

Very nicely and precisely made the video and the content, I was not able to get the data on same file and getting error that file is being used

[@mohammedziaullah3176]

VEry Helpfull, Thanks.

[@TheHuntingRooster]

Exactly what I wanted. Cheers!

[@vasureddytamma5693]

Thanks bro save my time alot

[@Waterloo2021]

Thanks, what if the number of rows in consolidated sheet becomes greater than 1 mio?

[@SriBus]

What if i want to add second row as header what formula is for that case?

[@omprakashojha9698]

Great lesson. Thank you

[@Whacks]

Legendary video, thank you so much!

[@GoodlyChandeep]

Glad you like it! 💚

[@TheJiten123]

Thank you very much for wonderful explain

[@ZeroPayonPC]

excuse me sir, at 3:54, how can i remove desired top row number for all table, all my sheet are same form so...Hoping ur answer to come soon

[@samuelomodogoh]

Thanks a lot for this video. Is possible to just merge the first 100 data from each sheet?

[@ambikakokiloo5031]

Brilliant! Thank you so much❤

[@eunicen4250]

Awesome. thanks man!!!

[@lyndabennett1396]

Amazing video! May God richly bless you for this wonderful tutorial 😊 This is much faster than other methods I’ve found that have you create individual sources per sheet, or try to use buggy VBA code.

[@saravananm2304]

Thanks a lot Chandeep

[@MrJayDee4]

DAMN, This was AWESOME thank you bro

[@GoodlyChandeep]

Glad you like it!

[@yahya-imammunir7381]

Thank you for the excellent tutorial

[@cbpatil2620]

Hi Chandeep, your demo is excellent and i am not finding get data option, please guide me...

[@sortedsandy]

This is really helpful... Other channels were showing by creating the table... What if I have 500 sheets I don't want to create those many tables...

[@NirmalPrajapati-ry3ko]

Thanks Brother

[@AkhtarHussain-ct2hr]

How can I retain the formated field the same way after unpivot, for example when I change a field to currency, after pivot I lose the $ sign and the ,'s.

[@anbumadhuindustrial2279]

Very helpful. thankyou,

[@CAKPRashique]

Awesome, is there any specific book to suggest, to learn power query in detail

[@GoodlyChandeep]

In the meantime, you can check out this book -kzbin.info/www/bejne/d2eUfH2qabFrbbMsi=vK6wV5m85mqErqof Also, my book is coming soon, so stay in touch for any updates :)

[@ravidesai1672]

Thank you it works😊

[@pradeeps3808]

Hi sir, how to do the same in google sheets, could you please let me know

[@sanjeevkhakre2990]

Great learning

[@barthloney6608]

This is very clear and easy to follow, but I am not able to get the data to refresh after updating a source sheet. Thoughts?

[@roshwellhendricks313]

Hi Chandeep -- This is a life saver. Just one query, I wish to replicate the same on Excel web. Is it possible? My team and I want to work on the online excel and input respective data so that the same is auto inputted in the consolidated lis

[@llit1490]

Amazing yaaar🎉🎉

[@mariemaedemos1676]

THANK YOU SO MUCH😭

[@prajaktakale6503]

What if the data is / headers are different, how to consolidate the data?

[@kennethsmith9610]

How are you connecting to a workbook while it is in use? Without an error?

[@artistharry4339]

what if I want to combine different columns from different sheets into a single sheet dynamically?

[@TacomaFelizardo]

After you create the consolidated sheet will new data added to the individual sheet automatically update in the consolidated sheet? Great Video!

[@meganghormley6735]

Thank you!!

[@GoodlyChandeep]

Welcome!

[@saahilkhan8493]

I have a different sheets same like inventory with duplicate names of the items but I want it to be consolidated without being duplicate but the qty should not change Ex. Screw 5 inch 10pcs , screw 5 inch 50pcs

[@pitsob]

I need your assistance with merging a bit of a complicated file

[@naagarentertainment8666]

Hi chandeep, when i will refresh all data will loaded double the time

[@divyanshverma4787]

Thanks a lot.

[@AmitKumar-kr5nq]

my excel are old version please suggest me how can i combine multiple sheet in one sheet, there is no option of get data in my excel sheet

[@ivanablazevic3901]

Thank you! Time saver! :)

[@minidarling]

Hi Chandeep, Lets say I get a new copy of the same sheet every week to combine. Is there a way to automate it?

[@neelammishra5622]

Hi Chandeep, When I select the folder option (as shown at 1:51 in video), my options of Load/transform data get DEHILIGHTED. I tried to look for some setting issue if it is, but unable to resolve. So what should I do if more spreadsheets are added in future in my datasheet??? Thanks for sharing knowledge with the world.

[@darceyciccone3509]

Not sure if you figured this out by now, but two help others, in my Mac version this happens also. But, right click on the top level folder and I get a menu with "Transform Data".

[@ShamimAhmad21]

Hi Boos - I have multiple workbook and each workbook have multiple worksheet, so how we compile all worksheet in single Book.

[@rohanshetye1633]

Hi... Can u assist as in ... How to obtain the data on refreshing the consolidated file for a new sheet inserted in the existing workbook with the same headers?

[@1guitarkid]

Hi this is great but for some reason when i use tables to do this it is not refreshing?

[@thebhaskarjoshi]

this was fantastic

[@GoodlyChandeep]

Thank You 💚

[@taimooryaseen9661]

This fantastic bro I need you help

[@Kacess]

thanks it helps

[@yursnly]

How can you use the to connect to the same file while it is currently open? It is showing process currently in use error if you attempt to choose the same file.

[@GoodlyChandeep]

Get Data > From File > From Workbook (Make sure your file isn't on One Drive)

[@Tushar-o4c]

Thanks ❤👍🏻

[@ahmedmohsenzeid6256]

How to promote 2nd row as a header

[@SriBus]

Load data to existing worksheet option is disabled in my system how to enable that otherwise it creates different consolidated sheets. Kindly reply.

[@michaelmaillis3377]

I follow the steps and when I am to Import the Data I do not have the option to add it in my existing worksheet. When I add to a New Worksheet, then I get duplicate the sheets I wanted to aggregate in a form of a Table. When there is the expand option should I opt in for Aggregate instead of Expand?

[@dpecoraro66]

Hello Chandeep. I learned a lot from this tutorial; however, if I am combining sheets with the same ID say, and I want the other fields that pertain to that ID from other sheets, how can I get all the data within the same row for the ID without removing duplicates?

[@Pa1KumarSistla]

Explanation is Crystal Clearly Good CCG - Chandeep Chabra of Goodly :)

[@shraddhamahajan9864]

Thank you

[@avi2546]

Hi Chanddep. As we are using same file to prepare Consolidated sheet, now if i want share the file with others they get error to find that data source couldn't find. Is there any way that everytime the query pick the file in the same file in which i am working, even if i rename itor save it somewhere else?

[@avi2546]

I have found the way from other video. First convert all the sheets in TABLE Then create a query for each query GET DATA ->> FROM OTHER SOURCES ->> BLANK QUERY ->> in the formula bar type "Excel.CurrentWorkbook()" Next time you just update the data in the sheets and refresh the queries

[@brahmareswar]

Hi, Thanks. Pls explain how to consolidate the data from Multiple Excel files.

[@GoodlyChandeep]

kzbin.info/www/bejne/o4vFdWuXmdp8gLc

[@jasubi2695]

I need to combine sheets that are NOT related at all and have inconsistent headers. Please help! I've not been able to find a video.

[@arfanrasheed9941]

Dear Chandeep would you please give an example power query using medical students data, I am badly need to understand it

[@janardhanansgm521]

Thanks Bro.. Working awesome :)

[@GoodlyChandeep]

Super!

[@AliceRobinson-r1i]

Hi Chanddep! Thank you for your tutorial. I have a question, I have multiple reconciliation sheet which I would like to summaries the balancing total. Do you have a solution?

[@smfarnsworth]

Hi Chandeep - this work perfectly until the very end... It won't let me specify the current worksheet and instead summaries my 7 sheets in another 7 sheets :). I've re-watched the video at least 5 times and paused and copied exactly and can't see what I'm doing wrong???

[@kristenduda5218]

Dude!! You rock.

[@GoodlyChandeep]

Thanks. Glad it helped!

[@irenesanjay]

i have a query on this method which is useful. i am unable to open the same file while opening the location where it is saved