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