Find empty cells, fill with text from cell above

M

Marketer

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top