How to copy value from first row and past it into all the rows below

[Sshasnk]

Input: 

Time

112611

112611

112612

112612

112613

Expected output:

Time

112611

112611

112611

112611

112611

I am trying to copy the value from first cell to all cell below

[marcusblackhill]

Hello!

I think you can put a record ID and use a multi row formula, where if the ID is 1 you put the value of the row, else put the value of the row above, look my example.

[Kenda · Accepted solution]

Hi @Sshasnk 

You could use a Multi-Row Formula here with this expression:

[Row-1:Time]

Don't forget to set the drop down in the configuration to "Set to Values of Closest Valid Row" as shown:

[Sshasnk]

Perfect !!