separate a chain in more than 2

Five Stars

separate a chain in more than 2

How can I separate the value of a string by more than 2, delimiting it by ";"

CategoryProyType
Técnica, Técnica, Técnica, Técnica, Técnica173Externa; Externa; Externa; Interna; Interna
Administrativa; Administrativa; Administrativa; Administrativa186Externa; Externa; Interna; Interna
Financiera; Financiera158Externa; Externa



To appear as follows..

 

Caterory_1Caterory_2Caterory_3Caterory_4Caterory_5ProyTipo 1Tipo 2Type_3Type_4Type_5
TécnicaTécnicaTécnicaTécnica 173ExternaExternaExternaInternaInterna
AdministrativaAdministrativaAdministrativaAdministrativaAdministrativa186ExternaExternaExternaExterna 
FinancieraFinanciera   158ExternaExterna   

Accepted Solutions
Eight Stars

Re: separate a chain in more than 2


All Replies
Eight Stars

Re: separate a chain in more than 2

Five Stars

Re: separate a chain in more than 2

thank you very much!!

Eight Stars

Re: separate a chain in more than 2

Please give kudos (like button) to answers, if it helped.