We have a data in the following format.

Column 1	Column 2	Column 3	Column 4
A		D				X
B		E				Y
C		F				Z
		G

There is no limit to the number of columns. Each Column has some data in the Cells below it.

The challenge is to transpose this data into this format.

A	Column 1
B	Column 1
C	Column 1
D	Column 2
E	Column 2
F	Column 2
G	Column 2
X	Column 4
Y	Column 4
Z	Column 4