Replacing nulls

[Melissa]

Hi @ells,

Try something like this.

Table.TransformColumns( #"PreviousStepName",
    {"YourColumnName", each List.ReplaceMatchingItems( {_} , {{null, "..."}, {"", "..."}}){0} } 
)

I hope this is helpful