FILTERING MULTIPLE COLUMNS

[KamenRider]

Hi Guys,

What will be the syntax in filtering multiple columns where all should be null. The input file look like this for example.

 

And the results should look like this. Can Filter tool able to remove the row where the last 4 columns are null. 

 

Here's the excel file attached.

Thanks,

Kamen

[juvillalobos]

Use the filter tool and use the following formula 

IsNull([Column1]) AND IsNull([Column2]) AND IsNull([Column3])

Change the name of the columns for your columns and that should be enough. 

[Raj · Accepted solution]

@KamenRider find the workflow attached
mark done if solved.

[Raj]

@KamenRider the solution is dynamic and will work for N number of columns.