I am trying to join/paste columns from two files for the rows with matching first field. Any help will be appreciated.
Files can not be sorted and may not have all rows in both files.
Thanks.
File1
aaa 111
bbb 222
ccc 333
File2
aaa sss mmmm
ccc kkkk llll
ddd xxx yyy
Want to generate:
aaa 111 sss mmmm (column 2 from file1 and clolumns from file2)
bbb 222 ????? (missing data, identified)
ccc 333 kkkk llll
ddd ???? xxx yyyy (missing column 1 data marked as missing.)