Organizing Columns w/ First and Last Names

[ajrev]

Hi,

I'm working on a stats project and need some help.

I've got my two columns, one for first names and the other for last names, and I'm trying to figure out how to merge them so they read in one cell as the full name and then alphabetize them by last name; if it is possible.

I've gone as far as using the concat function to merge the two columns, but can't alphabetize like I want to. I've got it to where it sorts it by first name though.

Thanks for the help!

 

[Akuini]

Why not sort the data by last name then combine them using the concat function?

 

[Michael M]

Why don't you sort by last name first, THEN join the names ??