Shell Programming and Scripting

K123 X CATA 3
K123 Y CATA 4
K123 Z CATA 2
K123 X CATB 5
K123 Y CATB 2
K123 Z CATB 2
B65 M CATB 3
B65 N CATB 4
B85 X CATA 1
B85 Y CATA 4
TR4 X CATA 3
TR4 Y CATA 2
TR4 Z CATA 2
TR4 X CATB 2
TR4 Y CATB 3
TR4 Z CATB 2
U23 X CATA 3
U23 Y CATA 1
U23 Z CATA 2
U23 P CATA 2

ITEM CATA/CATB
K123 X3Y4Z2/X5Y2Z2
B65  ---/M3N4
B85 X1Y4/---
TR4 X3Y2Z2/X2Y3Z2
U23 X3Y1Z2P2/---

$ grep CATA ttt.txt | awk '{A[$1]=A[$1]$2$4}END{for (i in A) print i" "A[i]}'
K123 X3Y4Z2
U23 X3Y1Z2P2
TR4 X3Y2Z2
B85 X1Y4


$ grep CATB ttt.txt | awk '{A[$1]=A[$1]$2$4}END{for (i in A) print i" "A[i]}'
K123 X5Y2Z2
TR4 X2Y3Z2
B65 M3N4

cat check_format1211.ksh 
awk '{V=$3;{if($3=="CATA"){A[$1 OFS $3]=A[$1 OFS $3]?A[$1 OFS $3] $2$4:$2$4} else {B[$1 OFS $3]=B[$1 OFS $3]?B[$1 OFS $3] $2$4:$2$4}}} END{for(i in A){print i OFS A[i] >> "CATA_results"} for(j in B){print j OFS B[j] >> "CATB_results"}}' format_output121

awk 'BEGIN{print "ITEM CATA/CATB" >> "FINAL_OUTPUT"} FNR==NR{A[$1]=$3;next} ($1 in A){print $1 OFS $3"/"A[$1]} !($1 in A){print $1 OFS $3"/-----"}' CATB_results CATA_results  >> FINAL_OUTPUT

awk 'FNR==NR{A[$1]=$3;next} !($1 in A){print $1 OFS "-----/"$3}' CATA_results CATB_results >> FINAL_OUTPUT

cat FINAL_OUTPUT 
ITEM CATA/CATB
B85 X1Y4/-----
U23 X3Y1Z2P2/-----
K123 X3Y4Z2/X5Y2Z2
TR4 X3Y2Z2/X2Y3Z2
B65 -----/M3N4

awk     '               {I[$1]
                         for (i=1; i<=Ccnt && $3 != C[i]; i++);
                         if (i > Ccnt) C[++Ccnt]=$3
                         T[$1, $3]=T[$1,$3] $2 $4}
         END            {printf "ITEM\t"
                         for (j=1; j<=Ccnt; j++)
                                {printf "%s%s", DL, C[j]
                                 DL="/"
                                }
                         printf "\n"
                         for (i in I)   {DL=""
                                         printf "%s\t", i
                                         for (j=1; j<=Ccnt; j++)
                                                {X=T[i,C[j]]
                                                 printf "%s%s", DL, X?X:"---"
                                                 DL="/"
                                                }
                                         printf "\n"
                                        }
                        }
        ' file
ITEM    CATA/CATB
K123    X3Y4Z2/X5Y2Z2
U23     X3Y1Z2P2/---
B65     ---/M3N4
B85     X1Y4/---
TR4     X3Y2Z2/X2Y3Z2