Thank you to this wonderful community for helping me in so many ways!

I have another formula-related question:

I have several columns with drop-down menus for different demographic groups, and I need to create a combined column with just the names (only one name per row. the demographic groups see only their column).

I've used this formula from another example this group helped me solved:

=IF([OHNS Faculty]@row <> " ", [OHNS Faculty]@row) + IF([OHNS Affiliated Faculty]@row <> " ", [OHNS Affiliated Faculty]@row) + IF([OHNS CIs/Fellows/Instructor]@row <> " ", [OHNS CIs/Fellows/Instructor]@row) + IF([OHNS Resident]@row <> " ", [OHNS Resident]@row) + IF([OHNS Administrative Staff]@row <> " ", [OHNS Administrative Staff]@row) + IF([Other Full Name]@row <> " ", [Other Full Name]@row)

but i get a "0" if it's any column but "OHNS Faculty" and extra commas for all the columns, but the last one "Other Full Name" like so:

• OHNS Faculty Last Name, OHNS Faculty First Name,
• 0OHNS CIs/Fellows/Instructor Last Name, OHNS CIs/Fellows/Instructor First Name,
• 0OHNS Resident Last Name, OHNS Resident First Name,
• 0OHNS Administrative Staff Last Name, OHNS Administrative Staff Last Name,
• 0Other Full Name Last Name, Other Full Name Last Name

How can i get rid of zero at the beginning and a comma at the end of each name (in between Last/First name is fine).

Thank you!