Forum Discussion
Anonymous
3 years agoNot applicable
How to delete rows with blank data without deleting the first row
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
mlsx4
3 years agoMemorable Member
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