Hello,



I have a master customer list. In Column A lists the customer name, Column B part number, Column C part description etc.

I want to sort on the customer name. The problem is the spreadsheet has grown over time and when it was first created the customer name was only entered once into column A. Orders where listed in column b, row1, then row2, then row 3 etc. The customer name wasn't copied and paste down into the rows below it.

If the xls was small I would manually copy and paste into the missing rows, then I can sort on customer name. However the xls is 30000 lines long so I want a formula to copy down the name from the row above until it finds a cell that has text in it. then I want to copy this name down for all blank cells below it until the next cell with text in it. i want to repeat this for the entire column. any ideas?

In short, the text in cell A1 should be copied into cell A2 if cell 2 is empty. then the text in cell A2 should be copied into cell A3 if cell A3 is empty until if finds a cell that isn't blank. the contents of this cell (which will be different from the cells above it) should be copied down into the cell below it (if its empty) etc. this process should be repeated.

Try this...

Fill range with values from cell above

• Highlight range from first cell to last
• Select F5 >> Special >> Blanks >> OK
• Press “=” sign one time then up arrow one time
• Press Ctrl + Enter
• Highlight range >> copy >> paste special as value