Forum Discussion
JL2007
1 year agoFrequent Visitor
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!
Solution here