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