Removing blank cells...
 

Cells B38:B90 either are blank or have text in them. I would like a formula
in cell I38 to find the first cell in B38:B90 with text in it and have that
text entered into cell I38. I would like cell I39 to find the next cell in
B38:B90 that has text in it and have that text entered into cell I39 and so
on. Thanks for the help.