Is there a way -

[JEC8878]

Hi All

I have received a spreadsheet with a vast amount of data. However the dates have been entered sparsely and i need the date to be on each individual row - See attached example - is there a simple way to do this
Each date corresponds to the blank rows underneath it ??

 

[Debaser]

Select the data (including blanks). Press F5, then the 'Special...' button and choose Blanks, then OK. Now type = then press the up arrow, then Ctrl+Enter.

 

[pecoflyer]

Power Query solution -( BTW cell C37 was not bank. Had to delete it first)
You can add or delete any number of dates, then Data - "Refresh all" and the fill down is excuted for the entire range

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Filled Down" = Table.FillDown(Source,{"DATE"}),
    #"Changed Type" = Table.TransformColumnTypes(#"Filled Down",{{"DATE", type date}})
in
    #"Changed Type"

 

[pecoflyer]

Select the data (including blanks). Press F5, then the 'Special...' button and choose Blanks, then OK. Now type = then press the up arrow, then Ctrl+Enter.

The only flaw here is that C37 is not empty, so it won't work for that cell ( contains a code 32 = space). If this will happen again in your range, please let us know so that PQ solution can be adapted.

 

[p45cal]

please let us know so that PQ solution can be adapted

In this case, if you change type before filling down, all is OK!