Forum Discussion
Remove empty rows from table
Hello, I am trying to remove the empty rows of a table. but only when all cells of a row are empty as shown in the image below. I need the table to remain as a table (not converted to a range) ...
Pinherio I would go for Power Query. See attached.
Can't this be implemented by VBA?
Patterns are here How to delete blank rows in Excel with VBA, formulas and Power Query (ablebits.com)
VBA, Power Query and formulae with helper column. Relatively easy to do with Office Script as well if you use Automate.
Pinherio Sorry, I don't touch VBA. Power query is really easy and you can handle very large files. Set it up correctly once and you can use the script over and over again. Don't really understand why you think it's laggy. Your choice!
