I figured it out. Very sloppy but it worked. I added in Column A, the values of H on all lines that had a number and L on all of the blank rows. Then I used =IF(AND(A2="H")B2,"") which I copied down to all of the blanks. That filled in all of the second blank lines. Then I used =IF(AND(A6="H"),B6,B5) on the remaining blanks and those were filled in. Like I said, the hard way but at least I got where I was going. Thanks!!