convert table

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

Hi mirmat and welcome to the forum,

I call this problem a CrossTab to Table problem. I have written code to do the conversion for converting Cross Tab tables to Excel Tables. See the attached with the Code where I've run it on a copy of Sheet1 on Sheet 2.