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