Remove empty rows

[Jaymond Flurrie]

I have problem with having a big database (currently 1260 rows) with lots of empty rows. All the rows are ok as-is, but I would want to move empty rows away. Or just to the bottom of the data set.

Here's an illustration of my data

Row 1: data-data-data-data
Row 2: empty
Row 3: empty
Row 4: data-data-data-data
Row 5: empty
Row 6: empty
Row 7: empty
Row 8: data-data-data-data
Row 9: empty
Row 10: empty
Row 11: empty
Row 12: empty
Row 13: data-data-data-data

One important thing is, that the number of empty rows between data series is not constant - Although there's always at least two empty rows. The total number of non-empty rows is constant 392.

[Jivo]

The shortest solution I know of is using F5 "GoTo" > Special cells > Blanks. and then delete entire row...

greets,

Ivo

[Jaymond Flurrie]

The shortest solution I know of is using F5 "GoTo" > Special cells > Blanks. and then delete entire row...

greets,

Ivo

What is the easiest way to automatize it? Do I need to use VBA?

And one problem is, that those empties are not really empty, they just have formulas that returns zeros.

[Jivo]

To automate it I would use VBA, but it's very easy with the Macro recorder. Just turn on the recorder, use "CTRL + *" for the current region and perform the sequence as described.

Your other problem could be solved by "copy" > "paste values" to a column not used. Then replace all 0 values with nothing. After that you have all blank values in the columns you want to get rid off.