UNIX for Dummies Questions & Answers

    2    3     4     5
2  0.0  0.0  0.1   0.1
6 -0.3  2.0  0.0   0.3
7 -0.6 -1.1  0.5   0.3
9 -0.9 -4.1 -0.7  0.5

2 2 0
2 3 0
2 4 0.1
2 5 0.1
6 2 -0.3
6 3 2
6 4 0
6 5 0.3
7 2 -0.6
7 3 -1.1
7 4 0.5
7 5 0.3
9 2 -0.9
9 3 -4.1
9 4 -0.7
9 5 0.5

awk 'NR>1{print $i}' sample.txt > temp1.dat
awk 'NR==1{n=split($0,c);next}
{for(i=1;i<=n;i++)s[++t]=$1 FS c[i] FS $(i+1)}
END{for(i=1;i<=t;i++){print s[i]}}' temp1.dat > temp2.dat 
awk '{print $1,$2,$3}' temp2.dat > final.dat

6 2 -0.3
6 0 2
6 0 0
6 0.1 0.3
6 0.1 
7 2 -0.6
7 0 -1.1
7 0 0.5
7 0.1 0.3
7 0.1 
9 2 -0.9
9 0 -4.1
9 0 -0.7
9 0.1 0.5
9 0.1

awk '
        NR == 1 {
                n = split ( $0, X )
        }
        NR > 1 {
                for ( i = 2; i <= n + 1; i++ )
                        print $1, X[i-1], $i
        }
' file