View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default how to transpose a table into two columns?

Check responses to your similar posting of a week ago:
http://tinyurl.com/ykakx5c

You should always follow up/feedback to each responder
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"pemt" wrote:
I have a table like this:
Name Value1 value2 value3 value4
A 1 2 3 4
B 4 3
C 5 6 7

How to convert it to two columns like this:
A 1
A 2
A 3
A 4
B 4
B 3
C 5
C 6
C 7

Thanks,

pemt