How can I copy and paste a value down in a column until the next value in a sequence?

[Sadsmileyface]

I have a sheet that comes out in a terribly unfriendly format. It has a date that appears in column C at variable intervals to denote the day that the times underneath it occurred.

I'd like the first instance of the date in C2 to be copied to A2, and then still paste that same date value into the likes of C3, C4 etc until the next date appears in column C, such as C7, then to take the value of C7 and paste it in A7 and repeat that sequence.

I think this would need to be VBA?

Example: https://pasteboard.co/HrXtYLX.png

 

[RoryA]

It looks like you could use a simple formula entered into A2 and copied down:

=IF(B2="Date",C2,A1)

 

[Sadsmileyface]

I now feel very embarrassed for asking. I've been over complicating it in my mind for days! Thank you very much!

 

[RoryA]

Really, you should be regretting not asking sooner.

Glad to help.