UNIX for Dummies Questions & Answers

awk '
{
        if (NR == 1) { print;next; }
        if (val1 != "" && $1 != lastkey) {
                print lastkey " " val1 " " val2 " " val3;
                val1="";
                val2="";
                val3=""
        }

        lastkey=$1;
        val1=val1 $2;
        val2=val2 $3;
        val3=val3 $4;
}
END {
        if (val1 != "") {
                print lastkey " " val1 " " val2 " " val3;
        }
}'

$ ruby -ane 'BEGIN{h={};h.default=""};$.==1and s=$_;$.>=2 and h[$F[0]]+=$F[1..-1].join;END{puts s;h.each{|x,y|print "#{x} #{y.scan(/.../).join(" ")}\n" }}' file
1 2 3
a x00 0p0 000
b 0bc a00 000
c q0s 0r0

awk 'NR==1{print;next} {a[$1]=a[$1]$2;b[$1]=b[$1]$3;c[$1]=c[$1]$4}END{for (i in a) print i,a[i],b[i],c[i]}' urfile