Merge columns with null

[joshua1990]

Hi experts!

I have a 3 columns with text values. Some cells are empty / value = null.

I added a merged column with a seperator "_". Now, if a column is null I don't get the seperator "_".

Instead of Value1__ (2 x "_") I just get Value1.

How can I get a seperator "_" if the column / value is null?

[Vijay_A_Verma]

If separator is same between all the columns, then Text.Combine will work

Text.Combine({[Column1],[Column2],[Column3]}, "_")

if separators are different between columns, then use Replacer.ReplaceValue. In below example, I am using _ and ** as separators

Replacer.ReplaceValue([Column1], null, "") & "_" & Replacer.ReplaceValue([Column2], null, "") & "**" & Replacer.ReplaceValue([Column3], null, "")

[Mahesh0016]

@joshua1990  please can you share your end output? Thank You!!