Hello all, I am very new to scripting and I have a challenging problem I would like to write a code for. Essentially, I would like to merge two tab-delimited spreadsheets that have identical column and row labels, one contains numbers, the other contains labels (text and numbers):
Spreadsheet 1
PHP Code:
gene W X Y Z
I 1 2 3 4
II 5 6 7 8
III 9 10 11 12
IV 13 14 15 16
Spreadsheet 2
PHP Code:
gene W X Y Z
I d1
II a3
III b1
IV c1
Merged Spreadsheet
PHP Code:
gene W X Y Z
I 1 2 3 4
d1
II 5 6 7 8
a3
III 9 10 11 12
b1
IV 13 14 15 16
c1
*Preferably, the column labels (W,X,Y,Z) would not have to be in the same order in both spreadsheets.
Any help appreciated!!
Thanks