D
DyingIsis
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
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