If it is just this one spreadsheet and just 2000 rows, it might be
faster to use a spare column to add a repeating sequence of 1 through 5
(as below). This takes a little time, but if you copy the first
sequence and paste, then copy the 2 sequences and paste, then copy the
four sequences and paste, etc...it wouldn't take more than a minute (I
just tried it to be sure).
A B C
A1 1,000.00 1
A2 Completed 2
A3 Misc data 3
A4 Misc Data 4
A5 5
A6 4,500.00 1
A7 Completed 2
A8 Misc Data 3
A9 Misc Data 4
A10 5
A11 1,452.25 1
.
.
.
A2000
Next, figure out which sequence number corresponds to the data you want
to keep (1 in this case), highlight the whole area, apply the
autofilter, and select the data you want by filtering out the other
sequence numbers. You could also select and delete the rows you don't
want, but you'd better make a copy first.