Hello, I need to find the intersection across 10 columns. Kindly help.
my file (INPUT.csv) looks like this
4_R 4_S 8_R 8_S 12_R 12_S 24_R 24_S
LOC_Os01g01010 LOC_Os01g01010 LOC_Os01g01010 LOC_Os04g48290 LOC_Os01g01010 LOC_Os01g01010 LOC_Os01g01010 LOC_Os04g48290
LOC_Os01g01019 LOC_Os01g01019 LOC_Os01g01019 LOC_Os05g39580 LOC_Os01g01019 LOC_Os01g01019 ChrSy.fgenesh.gene.29 LOC_Os05g39580
LOC_Os01g01019 LOC_Os01g01019 LOC_Os01g01019 LOC_Os05g39580 LOC_Os01g01019 LOC_Os01g01019 ChrSy.fgenesh.gene.29 LOC_Os05g39580
LOC_Os01g01010 ChrSy.fgenesh.gene.29
LOC_Os01g01010
There can be duplicate entries and the no. of entries in each column can be different.