Hello, I am new to shell scripts and 1st week into awk. I have so far managed to format output files to sample File 1 and File 2 as shown below and File 3 output solution is what I am looking for...thanks

File 1:
0633-009_001200008:225065338468009:CMBRTRM:albuterol
0633-009_001200008:225065338468009:CMCLAS1:respiratory system
0633-009_001200008:225065338468009:CMCLAS2:drugs for obstructive
0633-009_001200008:225065338468009:CMCLAS3:adrenergics
0633-009_001200009:225065338468008:CMBRTRM:albuterol
0633-009_001200009:225065338468008:CMCLAS1:respiratory system
0633-009_001200009:225065338468008:CMCLAS2:drugs for obstructive
0633-009_001200009:225065338468008:CMCLSCD3:R03C
File 2:
USUBJID|CMSEQ|CMBRTRM|CMCLAS1|CMCLAS2|CMCLAS3|CMCLSCD1|CMCLSCD2|CMCLSCD3|CMROUTE|
0633-009_001200008|225065338468009
0633-009_001200009|225065338468008

Need Output File 3 with Conditions:
File 1's Field 4 values ( seprated by ":" for example albuterol) appends to File 2 by
Field 3 value of File 1 ( for example CMBRTM) equals File 2 header separeted by | ( for example |CMBRTM|) and
for that row of insert File 2's field 1 and field 2 values is equal to File 1's field 1 and 2 values


Out put File 3:
USUBJID|CMSEQ|CMBRTRM|CMCLAS1|CMCLAS2|CMCLAS3|CMCLSCD1|CMCLSCD2|CMCLSCD3|CMROUTE|
633-009_001200008|225065338468009|albuterol|respiratorysystem|drugs for obstructive |adrenergics |||||
0633-009_001200009|225065338468008|albuterol|respiratory system|drugs for obstructive||||R03C||