Aligning 1st and Last name column in Excel with similar .jpg file name in separate column for SQL

mtarler  Thank you for your response.  See sample file.  Names have been changed, but basically I have copied the file name from the folder and pasted into a column on the document.  There are 684 names and over 1000 .jpg file names, so they do not line up if I try to ascend and alphabetically.  I am trying to get the Lastname_Firstname.JPG file to line up as seen in rows 10-13, I inputted these in manually.  

I appreciate your assistance with this.

Thank you!