How do I put 3 variables from 3 different data together by id?   I have 3 different data with common id number but different variables.   Data1 id variable1 1 a 2 b 2 s 3 c Data2 id variable2 1 d 1 e 2 f 3 g 3 h Data3 id variable3 1 I 1 j 1 k 2 l 2 m 2 n 2 o 3 p 3 q 3 r All I want is just putting these variables together by id in one dataset: Desired Dataset id variable1 variable2 variable3 1 a  d  I 1 .   e  j 1 .   .   k 2 b  f   l 2 s  .   m 2 .   .   n 2 .   .   o 3 c  g  p 3 .   h  q 3 .   .   r     How could I do that ?  neither merge nor inner join works this way. ... View more