Deleting Rows In A Pattern
 

Hello -

I have a data set from a Pivot table, and I want to delete every row with a
blank underneath Total. This turns out to be every 4th row. Is there a way to
automatically delete every 4th row in excel?

Any help is greatly appreciated.


Product Period Data Total
A Q1 Total Number of Items 1
Diff from Q1
Q2 Total Number of Items 4
Diff from Q1 3
B Q1 Total Number of Items 2
Diff from Q1
Q2 Total Number of Items 3
Diff from Q1 1
C Q1 Total Number of Items 3
Diff from Q1
Q2 Total Number of Items 2
Diff from Q1 -1
D Q1 Total Number of Items 4
Diff from Q1
Q2 Total Number of Items 1
Diff from Q1 -3