Want to generate same data from one row to the preceding rows

Komal_

Hi Team,

I have dataset as below, all am trying to do is get to the row which is "Code" in Data Set column and all the rows in value column before the "Code" row i.e. "Non Code" should be re written by the same value of "Code".

Note: There is huge data set similar to the below and there is no constant count of 

Data Set	Value
Non Code
Non Code
Non Code
Code	-1
Non Code
Non Code
Code	0
Non Code
Code	1
Non Code
Non Code
Non Code
Non Code
Code	2

Expected output

Data Set	Value
Non Code	-1
Non Code	-1
Non Code	-1
Code	-1
Non Code	0
Non Code	0
Code	0
Non Code	1
Code	1
Non Code	2
Non Code	2
Non Code	2
Non Code	2
Code	2

binu_acs

@Komal_ One way of doing this

Generate_Same_Data_18062024.yxmd