
One thought on this it to use calculated columns to simulate this effect. For example, if you had columns:
| FirstName
| LastName
| Honorific
|
| George
| Jetson
| Mr.
|
| Jane
| Jetson
| Mrs.
|
Create a column in the Layer Info window and use the Set Formula… button. Then, in the provided area, drag the columns into the space provided, adding spaces and making other changes by using the string operations. For example,
LastName+", "+FirstName
or
Honorific+" "+FirstName+" "+LastName
Which would yield:
| FirstName
| LastName
| Honorific
| First Calculation
| Second Calculation
|
| George
| Jetson
| Mr.
| Jetson, George
| Mr. George Jetson
|
| Jane
| Jetson
| Mrs.
| Jetson, Jane
| Mrs. Jane Jetson
|