Combine Data from Multiple Rows
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 ,
|