What about a macro then?
In this example, it would be done 45 times, but with a twist. If its blank, then the other cells in B,C,D, and E columns would also stay blank.