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

Consolidate Data
 

Hi Tim
have a look at the following website for instructions how to eliminate
duplicates
http://www.cpearson.com/excel/deleti...eDuplicateRows
http://www.cpearson.com/excel/duplic...gingDuplicates

--
Regards
Frank Kabel
Frankfurt, Germany

Tim wrote:
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