Hello,
I have the following table:
<tbody>
</tbody>
I'm looking for a formula that make this:
<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!
I have the following table:
CompanyName | Country1 | Country2 |
USA | England | |
England | USA | |
Spain | France | |
France | Italy |
<tbody>
</tbody>
I'm looking for a formula that make this:
USA | England | ||
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!