I have four text fields in my Content Type:
First Name Middle Name Last/Business Name (required) Generation
I want to combine these into one column in my view. I want the display format to be: LastName, FirstName MiddleName Generation
So only the last name is followed by a comma. The first name and middle name and generation only have spaces between them. I go to the Drupal view table settings and set the "Column" for all four fields to "Last/Business Name." But here's where I'm stuck: I know that there is a "Separator" field, but if I set it to a comma the format will be LastName, FirstName, MiddleName, Generation and that's not what I want.