Multinested previous()?

[#1]

Hi All,

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?

Regards,

Przemek

INPUT
---------
Name, City 
John, Berlin
Mary, London
, Paris
, Amsterdam
OUTPUT
-------------
Name, City
John, Berlin
Mary, London
Mary, Paris
Mary, Amsterdam

[hic · Accepted solution]

Yup.

If(Len(Trim(Name))=0,Peek(Name),Name) as Name

HIC

[#3]

Thank you, Henric.