I have a column that has 140K rows, but there are about 5K of blanks that I
need the contents of the row above it copied into it, but if there is already
data there to just leave the existing data alone - do not change or make
blank. It would take many hours to search and work each individually..

Help is there a possible formula that will work. Thanks!