View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tim[_23_] Tim[_23_] is offline
external usenet poster
 
Posts: 2
Default Consolidate Data

We want to do a customer mailing. The sample below shows how the data is
organized. We want to consolidate each unique name so it appears one time.
The following should result in 3 rows of entries so that we can print
mailing labels. We have 10,000 entries to consolidate.

Thanks in advance,
Tim


Abbott John 515 Kellingwood Dr Pgh PA 15238
Abbott John same
Abbott Paul PO Box 90836 San Diego CA 92169
Abbott Paul same
Abesss Ed 810 Penn Ave 5th Pgh PA 15222