This content has been marked as final. Show 2 replies
I've got a dataset with 2 columns where some records miss value in the first column. In these very records where values are missed I want to assign last value in the first column as shown below. I guess prevoius() will not work here. Do you have an idea how to solve it?
INPUT --------- Name, City John, Berlin Mary, London , Paris , Amsterdam OUTPUT ------------- Name, City John, Berlin Mary, London Mary, Paris Mary, Amsterdam