Copy values from previous row to next row until a row has data.
Hello Team,
I wanted your help to copy the highlighted data in fig:1 to the fields in the below which are blank.
Fig :1 Data :
Output :
I tried lag column but the blanks following the data could be any number, it need not be always 2 or 3 blanks cells following it
Note: Date may or may not be same for each Online Customer, but Vch No. is always unique for each Online customer