Removing Blank Rows in Excel - 2 DataSets, 4 different approaches and a clear winner - Power Query

Excel Olympics
Excel Olympics
9.3 هزار بار بازدید - 3 سال پیش - This video will teach you
This video will teach you how to remove blank rows from your data, which we all have to do from time to time. There are two stages to the problem—only Blank Cells and then Entire Blank Row. And there are even more stages to the Solution. Four all together. The GoTo special Command, basic filtering, TEXTJOIN function, and the grand finale, the Power Query Solution. You will notice that (once again) Power Query turns out to be the perfect tool for the job. It's another one of those "I wish these were built into Excel" tools in Power Query, and it just works perfectly. This tutorial was made using Excel 365, but most methods work with Excel 2010 and above. The exception being the TEXTJOIN function which is only available since Excel 2019. Chapters: https://www.seevid.ir/fa/w/GVzigaFHKC0​ Excel Olympics Animation https://www.seevid.ir/fa/w/GVzigaFHKC0 Introduction to Blank Cells and Blank Rows https://www.seevid.ir/fa/w/GVzigaFHKC0 Solution 1 - Simple Table - GoTo Special Solution https://www.seevid.ir/fa/w/GVzigaFHKC0 Solution 2 - Simple Table - Filter Solution https://www.seevid.ir/fa/w/GVzigaFHKC0 Solution 3 - Complicated Table - The TEXTJOIN solution https://www.seevid.ir/fa/w/GVzigaFHKC0 Solution 4 - Complicated Table - Power Query solution https://www.seevid.ir/fa/w/GVzigaFHKC0 Outro Gear Used: US Links Camera: Canon EOS R6 - https://amzn.to/3e9zxML Microphone: AKG C3000 (Analog Mic) - https://amzn.to/3tYd37w Audio converter: Zoom UAC-2 - https://amzn.to/3dgM8wS Laptop: Dell XPS 15 - https://amzn.to/3w8CyoK Lights: Elgato Key Light - https://amzn.to/3rurte7 EU Links Camera: Canon EOS R6 - https://amzn.to/3tubwGy Microphone: AKG C3000 (Analog Mic) - https://amzn.to/32pi2m0 Audio converter: Zoom UAC-2 - https://amzn.to/3amDRXP Laptop: Dell XPS 15 - https://amzn.to/3effMmT Lights: Elgato Key Light - https://amzn.to/3vcs6v9 Green Screen (visible in bloopers): https://amzn.to/3ajUm6Y Recorded With: Camtasia - https://www.techsmith.com/video-editor.html Subscribe for more Excel tutorials on the Excel Olympics YouTube Channel: http://bit.ly/EOYTsub Subscribe for the Excel Olympics Newsletter: https://bit.ly/3w3rkjK DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links that I provide I may receive a small commission with NO additional charge to you! Thank you for your support! #Excel #ExcelOlympics #gasperkamensek
3 سال پیش در تاریخ 1400/05/05 منتشر شده است.
9,355 بـار بازدید شده
... بیشتر