Shell Programming and Scripting

process_nameA    valueA
process_nameA    valueA
...
process_nameB    valueB
process_nameB    valueB
...
process_nameN    valueN

process_nameA,process_nameB,...,process_nameN
valueA,valueB,...,valueN
valueA,valueB,...,valueN

awk '!Arr[$1]++ {print $1 > "XYZ_"$1} {print $2 > "XYZ_"$1}' file; paste -d, XYZ_*; rm XYZ_*
process_nameA,process_nameB,process_nameN
valueA,valueB,valueN
valueA,valueB,valueN

awk '
        {
                if ( R[$1] )
                {
                        c = R[$1]
                        c = c + 1
                        A[$1","c] = $2
                        R[$1] = c
                }
                else
                {
                        c = 1
                        A[$1","c] = $2
                        R[$1] = c
                        H[++j] = $1
                }
                m = m < c ? c : m
        }
        END {
                for ( i = 1; i <= j; i++ )
                        printf "%s", ( i == j ? H[i] : H[i] OFS )
                printf "\n"
                for ( k = 1; k <= m; k++ )
                {
                        for ( i = 1; i <= j; i++ )
                        {
                                printf "%s", ( i == j ? A[H[i]","k] : A[H[i]","k] OFS )
                        }
                        printf "\n"
                }
        }
' OFS=, file.csv

awk '
{
  if ($1!=P) {
     v[++C,0]=P=$1;
     F=1;
  }
  v[C, F++]=$2
  M=(F>M)?F:M
}
END {
   for(j=0;j<M;j++) {
       for(i=0;i<=C;i++)
           $i=v[i,j]
       print
   }
}' OFS=, infile