Power Query - Combine columns, ignoring nulls

[Darkstar_]

I have a series of columns I wish to join. All containing text.
For each one I want a delimiter of the pipe symbol.

I merge the columns but I don't get what I want. Here is example of the data:

Mon	Tues	Wed	Thur	Fri
Mon	Tues	Wed
Mon

When I merge column I get this

Mon|Tues|Wed|Thur|Fri
Mon|Tues|Wed||
Mon||||


When all I want is:

Mon|Tues|Wed|Thur|Fri
Mon|Tues|Wed
Mon

I can do this in a flash in Excel with TextJoin, as that gives me the option to ignore blanks.

Any solution?

Below is my current code:

let
    Source = OUTPUT,
    #"Merged Queries" = Table.NestedJoin(Source, {"Reference Document"}, LIVE_LINKS__LOCAL, {"Filename"}, "LIVE_LINKS__LOCAL", JoinKind.LeftOuter),
    #"Expanded LIVE_LINKS__LOCAL" = Table.ExpandTableColumn(#"Merged Queries", "LIVE_LINKS__LOCAL", {"Tax.2"}, {"Tax.2"}),
    #"Merged Columns" = Table.CombineColumns(#"Expanded LIVE_LINKS__LOCAL",{"Taxonomy", "Tax.2"},Combiner.CombineTextByDelimiter("|", QuoteStyle.None),"Taxonomy.1")
in
    #"Merged Columns"

 

[alansidman]

let
    Source = Excel.CurrentWorkbook(){[Name="Table3"]}[Content],
    #"Merged Columns" = Table.CombineColumns(Source,{"Column1", "Column2", "Column3", "Column4", "Column5"},Combiner.CombineTextByDelimiter("|", QuoteStyle.None),"Merged"),
    #"Replaced Value" = Table.ReplaceValue(#"Merged Columns","||","",Replacer.ReplaceText,{"Merged"})
in
    #"Replaced Value"

 

[Darkstar_]

Thank you, but that doesn't seem to work.
It only replaces two ||. I still get the | at the end of a row etc.

 

[alansidman]

I see the issue. Working on a solution. It occurs when there is an odd number of null cells

 

[JGordon11]

let
    Source = Excel.CurrentWorkbook(){[Name="Table3"]}[Content],
    #"Replaced Value" = Table.ReplaceValue(Source,null,"@@@###",Replacer.ReplaceValue,{"Column1", "Column2", "Column3", "Column4", "Column5"}),
    #"Merged Columns" = Table.CombineColumns(#"Replaced Value",{"Column1", "Column2", "Column3", "Column4", "Column5"},Combiner.CombineTextByDelimiter("|", QuoteStyle.None),"Merged"),
    #"Replaced Value1" = Table.ReplaceValue(#"Merged Columns","|@@@###","",Replacer.ReplaceText,{"Merged"})
in
    #"Replaced Value1"

 

[Bo_Ry]

Please try

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    AMerge = Table.AddColumn(Source, "Merge", each Text.Combine( Record.ToList(_),"|"))
in
    AMerge