This content has been marked as final. Show 2 replies
I have the below data set where i only have Value column. What i would like to create is DesiredValue_Column. In other words, i would like to scan the contents of Value column and repeat the same number if Value column is not null. If value column is null then repeat the previous number from Value column until value column is not null.
For example after value =3, it is null there i repeat 3 until value = 6 and then i simply copy the content of 6. Hope this makes sense. Any guidance is appreciated. Thanks.