Deleting Empty rows

[Ravimarath]

I have an excel file with data and many empty rows are there in between the data. How to delete those empty rows

[Luke_C · Accepted solution]

Hi @Ravimarath 

You could use a filter tool to do this. There are options to filter fields on both 'is not null' or 'is not empty'. You probably want to use the empty option, which would cover both null cells and empty cells.

The data cleanse tool also has an option to remove rows that are totally null.

[Emmanuel_G]

Hi @Ravimarath,

Find attached an easy way to do this.

If you have empty values instead of null values, you can simply replace isnull function by isempty function.

[rively90]

@Emmanuel_G  NOT WORKING!!!!!!!!!!!!!!!!!!!

[Emmanuel_G]

Hii @rively90 

Can you open a new question in a community please ?

It will be more easy to help. You can add more context to your topic, a random data, etc.

Do not hesitate if there is a problem with that.