IF cell is empty, FILL cell with top value, ELSE skip

[Vladmill]

Hello Everyone,

The questions is how to fill the cell with top value if it is empty, if it is not empty -> skip.

The difficulty is that there is not connection or path between country <-> city.

Any help would be appreciated 😃

[MarcelBeug · Accepted solution]

You can fill down and use replace value with some dummy input.
Next adjust the generated code as in the query below.

An additonal step is required to restore the column types, as this use of Table.ReplaceValue changes all column types to "any".

let
    Source = Table1,
    #"Filled Down" = Table.FillDown(Source,{"Country"}),
    #"Replaced Value" = Table.ReplaceValue(#"Filled Down",each [Country],each if [City] = null then null else [Country],Replacer.ReplaceValue,{"Country"}),
    #"Restored ColumnTypes" = Value.ReplaceType(#"Replaced Value",Value.Type(#"Filled Down"))
in
    #"Restored ColumnTypes"