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

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

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.

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