Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Dear all,
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 |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
TRANSPOSE ROWS TO COLUMNS | Excel Discussion (Misc queries) | |||
Transpose columns to rows using first columns repeated. | Excel Worksheet Functions | |||
Transpose multiple columns | Excel Discussion (Misc queries) | |||
How do you transpose rows to columns? | Excel Discussion (Misc queries) | |||
Is it possible to transpose 2 columns of data into 1 row? | Excel Discussion (Misc queries) |