How to concat two unequal tables horizontally (not a simple ‘join’ case)
Table 1 looks likepatientassay result 1assay result 2assay result 310011a+10012b+10021c-10032d- Table 2 looks likepatientadverse event1001aaa1002aab1002aac1002aad1003bbb1003bbc The result I want to get looks like:(patient column is a 'shared column' for these two tables)patientassay result 1assay result 2assay result 3adverse event10011a+aaa10012b+ 10021c-aab aac aad10032d-bbb bbc Could s...