You can merge the first name and last name columns by following these steps: 1. Click Add Column > Merge columns
2. Input a formula to combine the two columns with a space in between
Source:Hide, Re-order, Sort, Filter, Merge Columns
To merge first name and last name with a space in between, you can use a formula column. The formula would be: firstName + " " + lastNameThis will combine the first name and last name fields with a space character between them.
.png){kind=logo}
