View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
pemt pemt is offline
external usenet poster
 
Posts: 15
Default 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