How to Ignore Blank Values Combining Columns

[JL2007]

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!

[Deku · Accepted solution]

Solution here