How To Combine Data From Multiple Text Into One Cell?

[jackgan]

I have a set of database which like like this:

Company Name Contact Mobile
AAA Jack 716-123-4567 714-792-8729
AAA Alvin 716-123-4567
Top Mary 800-896-7589 312-792-6348
Top Anson 312-758-4289
Top Peter 312-758-4289 312-789-1750
YBB Julie 517-975-8718 518-318-2185
YBB Liara 517-897-3298

And I would like it to be like this:
Jack
AAA Alvin 716-123-4567 714-792-8729
Mary
Anson 800-896-7589 312-792-6348
Top Peter 312-758-4289 312-789-1750
Julie 517-975-8718
YBB Liara 517-897-3298 518-318-2185

Or it will be better if can be like this:
Jack 714-792-8729
AAA Alvin 716-123-4567
312-792-6348
Mary 312-789-1750
Anson 800-896-7589
Top Peter 312-758-4289
518-318-2185
Julie 517-975-8718
YBB Liara 517-897-3298

Can anyone come out with an solution? This maybe complicated but I think there must be a way to do it. Thanks in advance.

[abousetta]

You will give us an explanation of the logic on you are converting the before data to the after data.

[jackgan]

Basically I want to come out with a list that the name of company will only appear once. So that the cell in first column will have the name of company, the cell in second column will have all the name of contact person, and the cell in third column will have all the contact number. All of these will only show in one row. Therefore I can filter by the company name and show me all the related contact information I want.