Hi guys,
I have around 200 rows in one tab and 600 columns in tab 2. I would like to find the rows and columns that match with each other and delete the columns that doesn't appear in the row names in tab 1.
so the row names in tab one are something like this:
and the column names in tab two are like this:
all the row names in tab 1 will appear in the column names in tab 2, so I would like to eliminate the names in tab 2 that does not show up in tab 1
Thanks in advance.
I have around 200 rows in one tab and 600 columns in tab 2. I would like to find the rows and columns that match with each other and delete the columns that doesn't appear in the row names in tab 1.
so the row names in tab one are something like this:
and the column names in tab two are like this:
all the row names in tab 1 will appear in the column names in tab 2, so I would like to eliminate the names in tab 2 that does not show up in tab 1
Thanks in advance.