Forum Discussion
Pinherio
Feb 25, 2024Copper Contributor
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
Feb 25, 2024Copper Contributor
Can't this be implemented by VBA?
SergeiBaklan
Feb 25, 2024Diamond Contributor
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.