Hi to all
Good Afternoon
I got genetic distance matrix based snp genotyping data of 10 individuals in matrix format and now I want convert it into data frame format like genotype1 in columnA and genotype 2 in column B and distance between them in column C and also rank them genotype wise for easy comparisons. Here I am attached my example data file for better understanding. I tried this with following code but I did not get exactly what I am expecting with this. I need your help in solving this problem and it saves lot of my time in comparing one genotype against another any help in this regard will be highly appreciable
here is my data file for better understanding https://www.dropbox.com/s/wo4tawgvhob476v/New Microsoft Excel Worksheet1.csv?dl=0. Till now I tried these formulas
=IFERROR(INDEX(TRANSPOSE($B$1:$G$1), CEILING(ROW()/COUNTA($A$2:$A$7),1),1) & "-" & INDEX($A$2:$A$7, 1+MOD(ROW()-1, COUNTA($A$2:$A$7)),1), "")
=OFFSET($A$1,MATCH(LEFT($J1,1),$A$2:$A$7,0),MATCH(RIGHT($J1,1),$B$1:$G$1,0)) but I am not getting what I am expecting with these.
Thanks in advance With Regards,
Good Afternoon
I got genetic distance matrix based snp genotyping data of 10 individuals in matrix format and now I want convert it into data frame format like genotype1 in columnA and genotype 2 in column B and distance between them in column C and also rank them genotype wise for easy comparisons. Here I am attached my example data file for better understanding. I tried this with following code but I did not get exactly what I am expecting with this. I need your help in solving this problem and it saves lot of my time in comparing one genotype against another any help in this regard will be highly appreciable
here is my data file for better understanding https://www.dropbox.com/s/wo4tawgvhob476v/New Microsoft Excel Worksheet1.csv?dl=0. Till now I tried these formulas
=IFERROR(INDEX(TRANSPOSE($B$1:$G$1), CEILING(ROW()/COUNTA($A$2:$A$7),1),1) & "-" & INDEX($A$2:$A$7, 1+MOD(ROW()-1, COUNTA($A$2:$A$7)),1), "")
=OFFSET($A$1,MATCH(LEFT($J1,1),$A$2:$A$7,0),MATCH(RIGHT($J1,1),$B$1:$G$1,0)) but I am not getting what I am expecting with these.
Thanks in advance With Regards,