Nonprinting 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/R...
Learn Power Query with Mynda here: https://www.myonlinetraininghub.com/e...
Follow Mynda on LinkedIn: / 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