Move Repeating and Non-Repeating Names into separated columns

Hello guys,
I know, I have made you enough bored with my football files, but I really need your help.

In the file, you will see league names and their countries. In some countries, unique league names are used, such as: USA - MLS League. But, in some countries, same names are used, such as Bundesliga are used both in Germany and Austria. In the file, you will see these along A and B columns. VBA code needs to move repeated and non-repeated league names into sepated columns with its countries.

Please check attached file. Thanks a lot for for your responses.

In column F and G, i made repeating leagues together. but they can be dispersed like this. No problem.
column-F-G.png

Please Login or Register  to view this content.

Thank you jindon.
I, in Turkey, am proud of yuto nagatomo and you endlessly

Originally Posted by FlameRetired

aaaaa34,
You are ignoring a Moderators' request!
Please post the link!

I've just fixed my post.