Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have several lists (for example: list 1 to 4) and would like to combine
them into a summary list. Does anybody know a good way to do this. Thanks a lot. Example: List 1: A 10 B 20 C 0.1 D 3 E 100 F 0.01 G 5 H 10 I 1 J 10 List 2: A 11 B 21 C 0.5 D 6 E 10 F 0.2 G 5 H 10 M 5 N 6 List 3: A 15 B 30 C 0.9 D 9 E 10 F 0.2 K 11 H 10 M 5 Z 1 List 4: A 20 B 40 C 1.5 D 12 E 10 X 3 K 11 H 10 M 5 Z 2 Summary List A 10 11 15 20 B 20 21 30 40 C 0.1 0.5 0.9 1.5 D 3 6 9 12 E 100 10 10 10 F 0.01 0.2 0.2 NA G 5 5 NA NA H 10 10 10 10 I 1 NA NA NA J 10 NA NA NA K NA NA 11 11 M NA 5 5 5 N NA 6 NA NA X NA NA 3 NA Z NA NA 1 2 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Combining 2 lists | Excel Discussion (Misc queries) | |||
Help with combining lists | Excel Worksheet Functions | |||
Combining Lists | Excel Discussion (Misc queries) | |||
combining two lists | Excel Worksheet Functions | |||
Combining 2 lists | New Users to Excel |