How to repeat first value into next rows?

[tomcatxx]

Hi there. A simple question.

C1
26082018

How Can I repeat that value into next row?  Use peek() pls.

Thank you.

[Quy_Nguyen]

Hope this help

A:
LOAD * INLINE 
[
C1
26082018,
27082018
28082018
];

B:
Load C1, Peek(C1) as LastValue
Resident A;
Drop Table A;

[sunny_talwar]

There is only one row in the sample data you provided... what exactly the output needs to look like for the above example?