How to delete rows with blank data without deleting the first row

[Anonymous]

Hi, Team.

Got confused how can I delete entire rows with blank data without touching or deleting the first row.



First Row

Thank alot

Ann

[ImkeF]

Hi @Anonymous ,
I cannot make sense of your screenshots, as none of the column headers seem to relate to each other.
Please revise and try to display the logic a bit clearer.
Also, creating a file with some sample data usually helps a lot.

[mlsx4]

Hi @Anonymous 

It could be a not elegant solution but you can create a conditional column where you check all the columns:

IF Column1<>null, return Column1

IF Column2<>null, return Column2
IF Column3<>null, return Column3

else null

In this way, if a any of the column has a value, it will keep it. Otherwise, you will get a null in the column and those are the ones you can remove

[PijushRoy]

Hi @Anonymous 

Please share image with Row no pane (left side ) and mention which rows you want to delete (line Row 3 and Row 4) and why want to delete

Thanks

Pijush

[Anonymous]

Hi, Pijush

Please see below screen shot I have the full details 

1 I wan to retain the first row even its blank as well

2 But I need to delete those with No Value in Org Unit 4

Thank you so much
Ann