Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 53
Default Combine 2 sets of data

Hi,

I have 2 Lists. I want to combine these 2 lists to have 1 List as i have
shown below. How can i do this?

List 1 List 2 Combined List
ID Name ID Name ID Name List 1Name List 2
1 RW 1 RPS 1 RW RPS
2 ROP 2 CPM 2 ROP ROP
3 RW 2 ROP 2 CPM
4 EPR 3 RW 3 RW RW
5 DCE 4 DCE 4 EPR DCE
5 RW 5 EPR 5 DCE EPR
8 SEG 5 RW 5 RW RW
8 FGE 6 NOT 6 NOT
8 TRE 6 RV 6 RV
8 JLR 6 RV 6 RV
6 ROP 6 ROP
6 RW 6 RW
8 FDS 8 SEG FDS
8 REW 8 FGE REW
8 TRE
8 JLR
Regards
Rajula
Reply
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
show 3 sets of data per data point in a scatter plot Marie Charts and Charting in Excel 6 May 19th 08 09:38 PM
is it possible to combine data sets, eliminating duplicates? [email protected] Excel Worksheet Functions 1 April 25th 07 05:01 PM
how do i link up 2 sets of data into 1 set of data in excel Mike Excel Worksheet Functions 2 October 21st 06 01:52 AM
help comparing two sets od data to find the odd data matsgullis Excel Worksheet Functions 2 January 12th 06 02:52 AM
How to combine two data sets with one category of variable in com. Brown New Users to Excel 2 March 23rd 05 12:14 AM


All times are GMT +1. The time now is 09:51 AM.

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

About Us

"It's about Microsoft Excel"