data = merge(data1,data2,by.x = "column1",by.y="column2",all=TRUE) //column1 from data1 and column2 from data2
#for merging coloumns merge(a,b...) #for merging rows (rbind(a,b...)