Custom or Conditional Column to Copy data to Null Cells

[SAMCRO2014]

I am trying to go through a column (CC) and when it finds a number (such as 120199999), I want power query to copy that number to the "Null" areas above it then find the next number in the column and do the same thing, and so on.

In VBA the coding would be:

'Copy cost centres in column A to blank cells above
With Range("A1:A" & LastRow)
.SpecialCells(xlBlanks).FormulaR1C1 = "=r[1]c"
.Value = .Value
End With

Do I need a custom column? I can't seem to getting the coding correct.

Any suggestions?

 

[SAMCRO2014]

I figured it out. I am trying to make this harder than it needs to be

 

[peter789]

Did it fill you up?

 

[SAMCRO2014]

Yes. I didn't realize it had that functionality. New to Power Query