Combine Data from Multiple Sheets into a Single Excel File | Most Dynamic Method

[@GoodlyChandeep]

Join my M course Today ↗ - goodly.co.in/learn-m-powerquery/ Download the Excel File used in the Video ⬇ - goodly.co.in/combine-data-from-multiple-sheets-into-single-excel-file Combine Data from Multiple Excel Files with Dynamic Columns & Sheets - kzbin.info/www/bejne/oaXKlXeGg72cg8ksi=Q2rFHpvbdD6haMs1

[@AK-ij9il]

Hi Chandeep Goodly, Is it possible to retrieve 3lakh rows table via API Calls and used this as a Data source in power BI?

[@msantosh1220]

Hi Chandeep, Are there any discount coupons/code available that I can avail for your M code course.

[@wildecorrea6477]

You're the best in Power Query! Thank you for sharing the file from the video!

[@vl21i]

Thanks for the detailed explanation of the steps and their functions. After I learnt how to dynamically read the files using File.Contents my PQ steps are clean without any dependency to sample queries. ❤ the way simple M codes help the data cleansing that too before loading the data

[@GeertDelmulle]

Good video, Chandeep, and I will repeat: List functions are the hidden power tools of the M language. ;-)

[@lmk001]

We get junk data all the time. This is very cool

[@chrism9037]

So great, thanks Chandeep

[@nazarkamal8831]

Amazing

[@cristhianramos4930]

Chandeep we need a video where you explain how to still just one row when there´re many rows with the same information but for example only 1 columns with different dates. Would be like group but with conditions. Thank you for your content

[@williamthedataprof]

Thank you buddy for the share. However, let' just say there's always a sacrifice one has to make or be aware of. In this case, being the owner of the data, I should know at least2 or 3 headers that I can anticipate and check for a row that contains such. Otherwise, the method you illustrated, in my opinion, is more troublesome because it assumes the data rows have no chance of missing data...

[@Faisal63045]

Thank you for sharing

[@alexrosen8762]

Thank you Chandeep! How is this different from combining data from multiple workbooks into a single sheet/excel file?

[@rkshivay4681]

Great 👍

[@vikashparihar8366]

What if we need to merge Sheets with multiple workbooks to multiple workbooks of a master sheet. Like, Workbook 1 of sheet 1,2,3 will be merged with Workbook1 of Master sheet. Similarly other workbook will merge with according workbook of Master sheet. I hv 3 sheets each with around 15 workbook. And requirement is to have a master sheet with 15 workbooks.

[@Rollacoastertycoon]

Does this work for multiple api calls to a single data flow like a loop When I try it says can’t because it’s dynastic

[@굿찬스-q4y]

What if there is junk column ?

[@dimmitrio]

In this case "null" method will not work correctly, need to use method when you look for exact column name like [Date].

[@dimmitrio]

But seems if we work with Tables in the column and not the sheets there have not to be junk columns.

[@brightonalbert3237]

thank you, but if you have more than 1 csv files

[@ebenezerasare9934]

the download file is not working

[@DJZG]

There's a workaround but you need to know a bit of html. Or for the purpose of the exercise, build your own custom table with few sheets and few rows of random data.

[@nazarkamal8831]

❤❤❤ Excel

[@zbatevp-vlogs610]

what I currently hate about power query is that it is slow. It's beautiful but its just slow.

[@RichardJones73]

And sometimes buggy, like you can't select drop down options sometimes

[@descendantsoftheheroes_660]

kya fayda itni skills ka ...jab tak north indian ko hinglish me nhi provide kr sakte

[@GoodlyChandeep]

www.youtube.com/@desigoodly :)

[@descendantsoftheheroes_660]

@@GoodlyChandeep dax ka module b complete nhi hai vha

[@GeertDelmulle]

I don’t speak Hinglish, but I do speak Denglish. LOL! :-)

[@descendantsoftheheroes_660]

@@GeertDelmulle I am discussing the individual who owns the channel responsible for posting the video.

[@yousrymaarouf2931]

Fantastic