I am not an expert and I need some help to solve a problem. I have two tables where the rows are molecules measured in blood and the columns are the different patients. The patients are totally different between the two tables, whereas the rows are mostly commons. How can I create a single table that combines the common molecules, maintaining the different ones?
Here an example.