=IF(A1="","",LOOKUP(REPT("z",255),$A$1:A1))


"Read" wrote:

I am trying to copy a cell value in Column A to Column B. I want to stop the
copy at a blank row and start the formula over referencing the new dataset.
Example:
Column A Column B
bread bread
943234 bread
234112 bread

milk milk
232134 milk
123134 milk