Return multiple values horizontally while removing duplicates

[kingi]

Hello,
I have the following table:

CompanyName	Country1	Country2
Facebook	USA	England
Facebook	England	USA
Twitter	Spain	France
Twitter	France	Italy

<tbody>
</tbody>

I'm looking for a formula that make this:

Facebook	USA	England
Twitter	Spain	France	Italy

<tbody>
</tbody>

For every company - it's countries, without duplicates (btw, the names of the companies in the second tables are already there)

Thanks in advnace!

 

[kingi]

So i decided to move to ONE column in my original table, so I have this formula that works perfectly: (ignore the cells numbers)


=INDEX($D$2:$D$23415, SMALL(IF($I$4=$A$2:$A$23415, ROW($A$2:$A$23415)-ROW($A$2)+1), COLUMN(A1)))


The only question is: How do I remove duplicates?