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