How do I combine the text values from multiple columns?
you can use the concat function in the formula tool, note here I also concatenated a space with the first and last name to make it look nicer: