Merging/copying different column info in several rows to ONE row

[Roq's Scout]

Hi,
Being a complete newbie/incompetent, I am having serious trouble finding a solution for my problem.
I am building a market segment database for my boss. This has made me combine company info from different shows into one excel file. This means most companies are listed several times (multiple rows), with only one slot used per several columns. There's 7714 rows. Ex:

Company	Segm1	Segm2	Segm3
10Gtek Transceivers Co., Ltd.	astronomy
10Gtek Transceivers Co., Ltd.		datacom
10Gtek Transceivers Co., Ltd.			fibers

I want to merge/copy info from rows which share the company name so that I in the end have this and can remove duplicates:

Company	Segm1	Segm2	Segm3
10Gtek Transceivers Co., Ltd.	astronomy	datacom	fibers
10Gtek Transceivers Co., Ltd.	astronomy	datacom	fibers
10Gtek Transceivers Co., Ltd.	astronomy	datacom	fibers

Attached half the file, the whole is to big. I understand that this should be doable by using =if, but I just don't get it. Can't find similar problems searching the forum either. Please help!
Thank you!

 

[WizzardOfOz]

1: first sort all by company name
2: Add three new columns at the end (seg1, seg2 & seg3)
3: for each of them
e2=if($a2=$a1,e1 & " " & b1, b1)
4: copy across and down
5: change seg1 .. seg3 into values (cut and paste as values to remove formula)
6: do a search and replace double space to single space " " to " ")