Use a pivot table. Info on pivot tables he
http://www.cpearson.com/excel/pivots.htm

Dave
--
Brevity is the soul of wit.


"MR" wrote:

I have a worksheet containing contact information. An individual may be
listed multiple times depending on what information is available for that
person. If they have a BusinessPhone and a MobilePhone they will be listed 2
times.

What is the best way to consolidate the rows?

Thanks!

Have:

A,B,C,D,
Name,BusinessPhone,MobilePhone,Email,
Jane Doe,,9992223038,,
Jane Doe,9992227258,,,
Jane ,
Buck Doe,,8884899742,,
Buck Doe,9992227059,,,
Buck ,


Need:

A,B,C,D,
Name,BusinessPhone,MobilePhone,Email,
Jane ,
Buck ,