Organize Data dump

[umehta]

I have a data dump I need to organize. It contains 12 columns. Th
first column is the company name and the remaining 11 are investors i
the company. The company can have multiple rounds of investing, s
each round creates the same company with different investors.

Example:

Comany Investor1 Investor2 Investor3 Investor4

IBM John Bob Mary Jane
IBM Mary Sarah
IBM John Bob Mary Sam
EMC Mike Joe
S Keith Matt

I'd like the data to look like the following

IBM Followed by all the investors (in all rounds) in on row

Any ideas? Pivot tables cannot get rid of the duplicate.

Thank in advance

 

[umehta]

I hope this helps

Attachment filename: investors.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=69574