LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11
Default combining several lists into one?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Combining 2 lists [email protected] Excel Discussion (Misc queries) 5 October 11th 08 12:50 PM
Help with combining lists lblunier Excel Worksheet Functions 1 July 23rd 08 08:56 PM
Combining Lists sethbroox Excel Discussion (Misc queries) 0 May 13th 08 05:35 PM
combining two lists karmaisgreat Excel Worksheet Functions 3 April 13th 06 09:16 PM
Combining 2 lists stevenrhonda New Users to Excel 1 March 5th 06 10:42 PM


All times are GMT +1. The time now is 06:54 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"