Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a 2 x 2 table:
C D A 1 2 B 3 4 I would like to tranform it into a list as follows: Row Column Value A C 1 A D 2 B C 3 B D 4 How do I do this in Excel. Of course my tables are much bigger than this and they are not Pivot Tables. thanks Joaquim |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Create List from a Table | Excel Discussion (Misc queries) | |||
Create list based on data table | Excel Discussion (Misc queries) | |||
How-to create a list from a summary table? (Office 2007) | Excel Worksheet Functions | |||
How to create list and count from a table? | New Users to Excel | |||
How to create a data list from a pivot table | Excel Discussion (Misc queries) |