Remove Blank Rows/Columns with Power Query Incl. STUBBORN Characters!

Non-printing characters, spaces and empty strings can make it difficult to remove blank rows and columns. This video shows two approaches ans shows you how to create a custom function you can use to automate the process. Download the example file here: https://www.myonlinetraininghub.com/Remove-Blank-Rows-and-Columns-from-Tables-in-Power-Query Learn Power Query with Mynda here: https://www.myonlinetraininghub.com/excel-power-query-course Follow Mynda on LinkedIn: https://www.linkedin.com/in/myndatreacy/ 0:00 Introduction 0:25 Example Data 0:41 Removing blank rows & columns using unpivot 2:59 Formula to automatically remove blank rows 7:38 Formula to automatically remove blank columns 12:16 Function to automatically remove blank rows