I've got a big table that looks like this:

A B C
1 USA English Spanish
2 England English
3 Canada English French

Now whenever there is any data present in column C I need to copy the row's content into a new row below, and insert the data in column B. So it looks like this:

A B C
1 USA English
2 USA Spanish
3 England English
4 Canada English
5 Canada French

I have been messing around but can't find a good way to accomplish this. Would anyone please help me?