yogi_Pull Into Sheet2 Data Sorted By LastName From FirstName_LastName Field Data In Sheet1

                                          Google Spreadsheet   Post  #1152
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Apr 24, 2013
user SRberg  :(http://productforums.google.com/forum/?zx=crpyw0e3sdva#!category-topic/docs/spreadsheets/pKbuYvsaLIA)
Editing a guest list
I am editing a quest list with names, addresses and emails.  How do I keep the rows together but sort them by column A, last word in the column? 
------------------------------------------------------------------------------------------------------------------------------
following is a solution to the problem