I have a spreadsheet where not every row is filled in first column. for
example, column 1 is customer name, column 2 is sales category, column 3 is
the customer sales for that category. A customer that purchased in 3
categories, only has the company name on the first record. So, the records
with no company name...are actually records for the same company above it.

I'm trying to figure out a way to search all cells in column 1, and if the
cell is empty, populate it with the text from the cell above it.