PQ #6 Part 2: Multiple Excel Files, Different Sheet Names Into Table with Combine Button
From excelisfun · · 4 min

The player loads from YouTube only when you click. It uses YouTube's privacy-enhanced mode.
If the video does not play, the owner may have turned off embedding. Watch it on YouTube instead.
Description
Download Zipped folder with files: https://excelisfun.net/files/PowerQuery06Part02Files.zip Free Power Query YouTube class from Mike excelisfun Girvin: https://www.youtube.com/playlist?list=PLrRPvpgDmw0lHaJfr4mjRcOMEYqKKvKBj Buy Mike Girvins Power Query M Code book: https://www.amazon.com/Transformative-Magic-Power-Query-Excel/dp/1615470832/ This video teaches you how to use the From Folder feature and Combine Files button to append 12 Excel files each with one sheet, but each sheet has a different name into one table with just a few clicks! Topics: 1. (00:00) Intro Song 2. (00:11) Introduction 3. (00:52) Download files so you can practice 4. (00:59) Difference in Excel File Structure between Video #6 and video #6 Part 2 5. (01:52) From Folder Feature 6. (02:23) Remove Other Columns 7. (02:27) Combine Files button 8. (02:54) Change Code to accommodate the fact that the worksheets have different names 9. (03:50) Summary 10. (04:05) Closing
View Power Query Video pdf notes: https://excelisfun.net/files/PowerQuery-06Part02.pdf
This video has subtitles or audio translations in these 71 languages: Abkhazian, Afar, Afrikaans, Amharic, Arabic, Assamese, Bangla, Bashkir, Basque, Belarusian, Bosnian, Bulgarian, Burmese, Cantonese, Catalan, Chinese, Chinese (Hong Kong), Chinese (Singapore), Chinese (Taiwan), Croatian, Czech, Danish, Dutch (Netherlands), Estonian, Faroese, Fijian, Filipino, Finnish, French, French (France), German (Germany), Hebrew, Hindi, Hungarian, Icelandic, Indonesian, Italian, Japanese, Korean, Latvian, Lithuanian, Luxembourgish, Macedonian, Maithili, Malay, Malayalam, Norwegian, Persian, Persian (Afghanistan), Persian (Iran), Polish, Portuguese (Brazil), Punjabi, Russian, Sanskrit, Scottish Gaelic, Serbian, Sicilian, Somali, Spanish (United States), Swahili, Swedish, Tamil, Telugu, Thai, Tibetan, Ukrainian, Urdu, Vietnamese, Welsh, Zulu. Click gear icon below video to set subtitles, audio and language.
#excelisfun #MikeGirvin #PowerQuery #Excel #PowerBI #PowerBIDesktop #Excel365 #LearnPowerQuery #freeclass #DataAnalysis #BusinessIntelligence #Microsoft #combine #excelpowerquery #import #append #combine #datacleaning #datatransformation #datatraining