You can do this, among others, using macros. The main point is: you want to be able to delete blank rows or rows that have blank cells quickly and easily.
This includes, for example, when you import an Excel worksheet into other applications, such as Access. Blank rows can generate several different problems.
In this tutorial, I focus on a very “dangerous”, annoying and common situation when working with data: the existence of blank rows and cells in data sets. Data scientists spend a substantial amount of time collecting and preparing data.Īs you're probably aware, the process of cleaning up data with Excel can be automated to a certain extent using tools such as Text functions or macros. You're probably aware of how annoying and time-consuming cleaning up data can be.
