Is this way of working help us out...

To capture the cell address of Paid and Wait total and store in a variable then check for the next paid & wait total. If the value of this is >0 Then delete the text inbetween the current cell and previous cell address...

Am not sure whether this will work out...

-Sindhuja