Remove space and nulls from list in PowerQuery-CodePudding

Is there a way to replace this (List.RemoveNulls(_)) with somthing like (each _<> "" and _ <> null)

I tried this and it did not work

Table.RenameColumns(
    Table.CombineColumns(BlanksToNull,mergeHeaders[List Of Headers For Concatenation], each Combiner.CombineTextByDelimiter("|", QuoteStyle.None)(List.RemoveNulls(_)),"Merged")
,{{"Merged",newMergedHeader}})

Thanks

CodePudding user response：

how about changing

Combiner.CombineTextByDelimiter("|", QuoteStyle.None)(List.RemoveNulls(_)),"Merged")

Combiner.CombineTextByDelimiter("|", QuoteStyle.None)(List.Difference(_, {" ",null})),"Merged")