Okay, so, here's what I'm working with and what I need to do:
All the cells in column BQ are filled with either "good", "bad" or are blank. It's mostly blank. I need to get rid of some of the rows where BQ is blank but not all of them. The rows I want to retain are all the rows where BQ has a value (good or bad, doesn't matter) AND the 2 blank rows that immediately follow.
So, if there exists a formula that can seek out every "good" or "bad" value in col BQ and then fill in literally any value into exactly 2 cells in the same column (BQ)? Then I can filter BQ for blanks and delete the remaining rows.
Or if anyone has another solution for this issue, I'm stumped.