Dear all,

How to transpose the below table into one column (actually 2 columns) with
name?
my table:
Name col1 col2 col3 col4
A 10 20 30 40
B 50 60
C 70 80 90

transpose into:
Name col1
A 10
A 20
A 30
A 40
B 50
B 60
C 70
C 80
C 90

Thanks,

pemt