If the loan count is 1 then merge to the next row. If last observation then merge with the previous row. Greatly appreciate your help in resolving this. Here is my data: Original Balance Loan Count Curr Balance Contrib IO Balance Contrib% WAC WAM (25,000 - 50,000] 1 116,294 7,412 0.0 4.47 317 (50,000 - 75,000] 12 711,046 43,812 0.2 4.52 337 (75,000 - 100,000] 33 2,906,308 186,190 0.8 4.49 331 (100,000 - 125,000] 24 2,651,113 144,296 0.6 4.48 332 (125,000 - 150,000] 1 5,807,462 383,168 1.7 4.51 331 (150,000 - 175,000] 59 9,304,718 643,080 2.9 4.52 329 (175,000 - 200,000] 83 15,377,836 984,286 4.4 4.50 342 (200,000 - 225,000] 69 14,498,236 889,785 4.0 4.50 340 (225,000 - 250,000] 84 19,678,015 1,278,485 5.7 4.50 340 (250,000 - 275,000] 76 19,644,538 1,156,395 5.2 4.50 339 (275,000 - 300,000] 1 20,128,657 1,117,135 5.0 4.50 343   Want: Original Balance Loan Count Curr Balance Contrib IO Balance Contrib% WAC WAM (25,000 -75,000] 13 827,340 51,224 0.2 4.50 327 (75,000 - 100,000] 33 2,906,308 186,190 0.8 4.49 331 (100,000 - 125,000] 24 2,651,113 144,296 0.6 4.48 332 (125,000 - 175,000] 60 15,112,180 1,026,248 2.3 4.52 330 (175,000 - 200,000] 83 15,377,836 984,286 4.4 4.50 342 (200,000 - 225,000] 69 14,498,236 889,785 4.0 4.50 340 (225,000 - 250,000] 84 19,678,015 1,278,485 5.7 4.50 340 (250,000 - 300,000] 77 39,773,194 2,273,530 5.1 4.50 341 ... View more