ExcelBanter - Combine Data from Multiple Rows

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Combine Data from Multiple Rows (https://www.excelbanter.com/excel-discussion-misc-queries/127531-combine-data-multiple-rows.html)

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 ,

Combine Data from Multiple Rows

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 ,