Hi.

I have two datasets (in two different worksheets) with same labels for the
columns, however, with different list of genes in each row. I am interested
in comparing the values when the gene is present in both datasets.

eg.)
dataset 1

qualityA quality B quality C
XP
2000
apple

dataset 2
quality A quality B quality C
fuji
XP
1998

what can i do to 1) find the genes that are present in both list
AND at the same time
2) to bring the relevant columns next to each other for comparison

i.e to make something that looks like

dataset 1 dataset 2
qualityA quality B quality A quality B
XP


thanks in advance