convert table

[mirmat]

Hi all,
Well, I have a problem with converting one table into another.
Here is my oryginal table:

	test1	test2	test3	test4
a	2
b		4
c	3		4	2
d
e			3	2

and i need to have sth. like that:

a	2	test1
b	4	test2
c	3	test1
c	4	test3
c	2	test4
e	3	test3
e	2	test4

I tried to figure out how to solve it quickly, and i was really suprised that it took me few hours without correct solution.
Any help, really appreciated.
THX