Grouping Fields

[ferha_jafri]

Hello Experts,

I have a requirement in which I want to group the countries but  I am not able to achive this, need help.

Input Data : 'USA', 'Canada', 'Mexico''Argentina', 'Brazil'

Output : 'USA', 'Canada', 'Mexico', 'North America'(this is a group of 'USA', 'Canada', 'Mexico'), Argentina', 'Brazil'

So I want North America along with all the countries so not sure how to achieve this.

Thanks in advance.