Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
show 3 sets of data per data point in a scatter plot | Charts and Charting in Excel | |||
is it possible to combine data sets, eliminating duplicates? | Excel Worksheet Functions | |||
how do i link up 2 sets of data into 1 set of data in excel | Excel Worksheet Functions | |||
help comparing two sets od data to find the odd data | Excel Worksheet Functions | |||
How to combine two data sets with one category of variable in com. | New Users to Excel |