I want to 1) get unique names AND 2) strip out vacancy AND 3) alpha sort AND 4) append Last name, first name.

The names are in Sheet1 and the results are in Sheet2.

I'm using =SORT(UNIQUE(Sheet1!A3:A), 1, TRUE) to do steps 1, 2 & 3, and that plops the first names in Sheet2 but I don't know how do step 4: to grab the corresponding last name in Sheet1 and append it to the corresponding first name in Sheet1 and put them in Sheet2.

  • 2
    Welcome. Please read on how to write and add a brief description of your search/research efforts as is suggested in How to Ask on this site. Also, please read how to and share a test sheet so as you can be easier helped. – marikamitsos May 13 '20 at 23:11
  • 1
    You should be aware that by choosing to share your spreadsheet, your email address will be unavoidably exposed. – Tedinoz May 14 '20 at 8:10
  • 1
    Here is a test sheet, created via a throwaway account. docs.google.com/spreadsheets/d/… – M. Schultz May 14 '20 at 15:59
  • Your sheet is private. Please change it to public – marikamitsos May 15 '20 at 15:48
  • You should also be aware that by signing up to stackexchange one's email is also unavoidably exposed to every stranger having access to the account details. And also to the public once the site is compromised. Same as when someone signs up in any site (Facebook, Pinterest, Vimeo, GitHub, myphonebill.com, myinsurance.com, sitexyz.com etc). In any case I think you use a great -and wisely, widely spread- alternative. – marikamitsos May 15 '20 at 16:17


  • Thanks. I think I have the sort & unique working fine. I'm stuck on how to drag to corresponding data to the sheet. – M. Schultz May 14 '20 at 17:00

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.