Forum Discussion
Solved
Merge selected columns ignoring null?
Following the solution provided here: https://community.powerbi.com/t5/Desktop/Table-Combine-How-to-handle-null-values/td-p/370001# I've been able to sucessfully merge the columns ignoring nu...
Hi, thanks for your help!
I figured it out, the solution was to simplify the formula from the link. Simply becoming:
= Table.AddColumn(#"Filtered Rows1", "Merged", each Text.Combine(List.RemoveNulls({[Name.1.1], [Name.1.2], [Name.1.3], [Name.1.4], [Name.1.5], [Name.1.6], [Name.1.7]}), "/"))
