Forum Discussion

JL2007's avatar
JL2007
Frequent Visitor
1 year ago
Solved

How to Ignore Blank Values Combining Columns

I'm trying to combine 3 columns so it read: Last Name, Middle Name, First Name. However not every field has data in it so I want to to ignore those blanks if they exist. What would be the best way to write this? Currently I have it like this (below) and it is combining the 3 columns but again if it's blank I want it to ignore that so there isn't a blank in the full name.

 

= Table.AddColumn(#"Changed Type1", "Full Name Merged", each [#"Last#(lf)Name"] & ", " & [#"Middle#(lf)Name"] & ", " & [#"First#(lf)Name"])

 

 

Thank you!

1 Reply