I have A and B.
Google working example here:
Sheet A stores data about patients.
Sheet B contains data about patients' vital signs that are collected.
I need to perform the equivalent of SQL Left Join on these two sheets, using ID column of both sheets as reference, such that the resulting C, would be: