Produce the design approach to generate the below sample target data requirement from the sample source data.
SRC FILE1 TGT FILE
Col1 Col2 Col1 Col2
101 A 101 CBA
101 B 102 D
101 C 103 E
102 D 104 F
103 E 105 HG
104 F
105 G
105 H
target file should be like the above .. please suggest answer