Rearrange records until specific condition

[HectorPaniagua]

Hi everyone! I need to asign in a new column, specific records in a column to all rows above that specific record. To be clearer I attached an Excel file with the example. 

Thanks for the help! 😁

[Felipe_Ribeir0]

Hi @HectorPaniagua 

One way of doing this (UPDATED ***)

[binuacs]

@HectorPaniagua One way of doing this

[HectorPaniagua]

Thanks a lot for your help, both answers were very useful! :D