How do I Transform certain fields from rows to colimns (SSIS and C#)

See more:

C#

Oracle

SSIS

Hello,

I'm struggling with building an SSIS package that will read data from Oracle Database and save that to .TXT file delimited in Tab format. But I'm looking for de-normalize the resultset depending on one field called CSERIAL, if that field is repeated in the resultset, then I will flip the following columns

(TYPENAME, TYPEVALUE, TYPESLOTNUM)

to 5 sets of three columns

(TYPENAME1, TYPEVALUE1, TYPESLOTNUM1......TYPENAME5, TYPEVALUE5, TYPESLOTNUM5) :
CBILLINGHEADEND CBILLINGLOCATION CBILLINGSTATUS CBILLINGSTATUSDESCRIPTION CSERIAL TYPENAME TYPEVALUE TYPESLOTNUM

110532295301 D SABVFCXMX 41 54:D4:6F:7A:AE:7B 1
110532295301 D SABVFCXMX 51 54:D4:6F:7A:AE:7A 2

That will be transposed to:

CBILLINGHEADEND CBILLINGLOCATION CBILLINGSTATUS CBILLINGSTATUSDESCRIPTION CSERIAL TYPENAME1 TYPEVALUE1 TYPESLOTNUM1 TYPENAME2 TYPEVALUE2 TYPESLOTNUM2 TYPENAME3 TYPEVALUE3 TYPESLOTNUM3 TYPENAME4 TYPEVALUE4 TYPESLOTNUM4 TYPENAME5 TYPEVALUE5 TYPESLOTNUM5
110532295301 D SABVFCXMX 41 54:D4:6F:7A:AE:7B 1 51 54:D4:6F:7A:AE:7A 2

If there going to be additional values they will fill the field for set 3 then set 4 then set 5.

I tried to do this using the script component but that didn't work with me.