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) ...
Riny_van_Eekelen
Feb 25, 2024Platinum Contributor
Pinherio I would go for Power Query. See attached.
Pinherio
Feb 25, 2024Copper Contributor
thanks 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.