In Power Query while merging multiple columns, can I create code to only add a separator (comma) if value occurs in columns?
Columns A, B, C, and D have names of individuals. I would like to merge all 3 columns to 1 with a comma separating each column entry. Some cells in columns may be empty resulting in an output such as below:
Name1,,,Name4
Current code I am using:
#"Merged Columns" = Table.CombineColumns(#"Expanded Clean Name1",{"Name1", "Name2", "Name3"},Combiner.CombineTextByDelimiter(",", QuoteStyle.None),"Name")
Any suggestion? Thanks!
Bookmarks