Repeat one column number of times there is text in another

Hi,
im formatting some AD-data in excel and my problem is the following. My data is as follows:

Group 1	Member 1	Member 2
Group 2	Member 4	Member 5	Member 6
Group 3	Member 2	Member 4	Member 6

And the prefered result would be:

Member 1	Group 1
Member 2	Group 1
Member 6	Group 2
Member 6	Group 3

In other words it would be just two columns and the member name repeats the amount of time it belongs to groups and of course the group name repeats just as many times.