Hi
you can do achieve it with help of tNormalize component but you job design should be like below.
tFileinput---tMap---tNormalize1---tBufferout1
\------tNormalize2---tBufferout2
|---tNormalize3---tBufferout3
now follow the steps.
in tMap create three ouput links.
add source columns till CA_14 then concatenate CA columns in one column named as CA_14. e.g. ca 14_0+"|"+ca 14_2+"|"+ca 14_3,
do the same in rest of the two output links for BU and KG
then configure tNormalize component with source respective column like CA_14 for first, KG_14 for second, BU_14 for third normalize component with "\\|" delimiter string.
you will get six rows for each then Marge all the three flow don the line to get the result.