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...