I need an advice on how group data. The best way to explain this is to make an example:
On one sheet i have two columns with following data:
A B
1st China
1st Japan
2nd China
2nd Japan
2nd Singapore

I need to group data on second sheet followingly by using a formula:
A B
1st China; Japan
2nd China; Japan; Singapore

If i use VLOOKUP i only get the first value of column B on the first sheet and not the others. So all i could think of was a complicated IF formula but i have too much data for that and i even don't want to start writing it.

Any help is welcome.
Thankyou!