Sharepoint 2010 - I have a country lookup column wherein multiple values can be selected and is linked to another column (Region column) linked to another list. As it is the Region duplicates when for example a user selects 2 countries from the Africa Region.
Example: When the user selects multiple african countries in the Country Column - Algeria, Angola, Zimbabwe.
The Region Column displays in the view - Africa, Africa, Africa.
In this case I would like that the Region shows Africa only once.