How to transpose the table below into 1 (actually 2) column with t
 

Dear all,

How to transpose the table below into 1 (actually 2) column with their name
tag?
my table:
Name col1 col2 col3 col4
A 1 2 3 4
B 5 6
C 7 8 9

Transpose into
A 1
A 2
A 3
A 4
B 5
B 6
C 7
C 8
C 9


Thanks,

pemt