Comments and blank rows should be easy enough to remove using a Filter transform alone.
Admin suggested using FILTER to remove blank rows.
I’m trying to create a dynamic formula so I can apply the process on different spreadsheets.
- Add condition per column: Not dynamic:
I was trying some figure out some variation of
IF ( Sum of empty cell (Filter --> Loop --> if ( Row 1+n is empty) ) GREATER THAN Count of columns THEN Delete Row.
But I think I’m confusing myself.
Any suggestions? I think I’m making it more complicated than it should be.