I have a spreadsheet with a number of blank cells in a column, I want to fill
these cells with a another cell value from a different column, the value
will need to change every time a non blank cell is reached, as will the data
to be put in to the next section of blank cells. I can send a small sample of
data if required.

Regards