Remove null rows and not considering the record ID

[Balrajh1]

Hello,

I am trying to remove null rows and not considering the record ID, as you can see below,

from this

to 

Thanks in advanced for your help and support.

[Emil_Kos]

Hi @Balrajh1,

You need to use filter tool and this formula:

!IsNull([First Name]) OR !IsNull([Family Name]) OR !IsNull([age])

I have created a workflow for you!

[Balrajh1]

What if I have 100 columns?

[Luke_C · Accepted solution]

Hi @Balrajh1 

To make it dynamic for any number of columns, something like this would work:

1. Transpose the data using the record ID as the key
2. Summarize by Record ID & Cound of Non-null values
3. Filter out records who have 0 as the count (indicating all records are null)
4. Join these records back to the main dataset.