How it works
This set of Function will do exactly what the name implies, Delete all Blank Rows or Delete all Blank Columns or Unmerge all cells and Delete all Blank Rows and Columns. The result will then be placed into a new sheet, to preserve the original.
How to use it:
Step 1
In the ‘More’ drop down of the Cleaning and Structuring group, click on either ‘Delete Blank Rows’, ‘Delete Blank Columns’ or ‘Unmerge All, Delete Blank Rows, Columns’.
Upon clicking, the function will be executed and a new sheet with the applicable items deleted will be populated.
