How can I move each row beginning with 0PAID STATUS up to the previous row beginning with 0ASMNT-NBR? (Note: the number of intervening rows varies).
0ASMNT-NBR 050473534-3 1987
0000000 92.74 9.27 .00 102.01
0PAID STATUS NOT PAID
0ASMNT-NBR 050474655-2 1988
0000000 246.09 24.60 .00 270.69
0PAID STATUS NOT PAID
0ASMNT-NBR 050476727-0 1986
0000000 675.34 67.53 .00 742.87
0PAID STATUS NOT PAID
0ASMNT-NBR 050477408-5 1988
0000000 330.17 33.01 .00 363.18
0285291 137.45 13.74 151.19
0PAID STATUS NOT PAID
0ASMNT-NBR 050477528-0 1987
0000000 141.70 14.17 .00 155.87
0PAID STATUS NOT PAID
0ASMNT-NBR 050478352-0 1988
0000000 195.10 19.51 .00 214.61
0PAID STATUS NOT PAID
0ASMNT-NBR 050478559-1 1987
0000000 153.72 15.37 .00 169.09
0284831 .00 .00 .00
0PAID STATUS PARTIAL PAID
0ASMNT-NBR 050478584-3 1987
0000000 339.70 33.97 .00 373.67
0PAID STATUS NOT PAID
0ASMNT-NBR 050478585-4 1987
0000000 264.91 26.49 .00 291.40
0PAID STATUS NOT PAID
Moving rows up
Moderators: AmigoJack, bbadmin, helios, Bob Hansen, MudGuard