Thread: how to transpose multiple rows into one column with row labeling?
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 multiple rows into one column with row labeling?
Dear all,

I need to convert the following table:
a 1 2 3
b 7 8
c 4 5 6 9

into:
a 1
a 2
a 3
b 7
b 8
c 4
c 5
c 6
c 9

how to do it?
thanks,

pemt
Reply With QuoteReply With Quote