View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ron
 
Posts: n/a
Default Merge different first name, same last name, same address

I have 3291 names and addresses. In order to avoid creating duplicate
labels, I want to merge rows that have the same last name and street address
but different first names.

Fr:
Jack Smith 123 Elm Street
Jill Smith 123 Elm Street

To:
Jack Jill Smith 123 Elm Street