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)
Orange (Result)
Thanks in advance.
5 Replies
Sort By
- Riny_van_EekelenPlatinum Contributor
Pinherio I would go for Power Query. See attached.
- PinherioCopper ContributorCan'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.
- PinherioCopper Contributorthanks for the suggestion, but I need to modify the same table, the data is large, and duplicating it as a query makes the file laggy.