How can I hide empty rows

Hi guys,
I have a long sheet, (not in a subtable format)
where each line represents a different expence,
now I would like to creat a rull that when the first field is empty i would like to delete the line.
is that possiable?

Hi, you can first query for empty values by following this instruction, and delete all filtered records afterwards.

thanks its a good idea
but i need it from a field not a subtable

Hi, do you mean you want to hide fields in the form page?