Unpivot single field question

Warning : this is totally n00b question , and I need to work more with unpivot

I have a data source which says
TicketID | CODE | Name
11,K234;K235,Prashant;Pulkit

I can easily split using single field using ; on CODE Field
which results in 
11,K234,Prashant;Pulkit
11,K235,Prashant;Pulkit

Is there a way to incorporate same delimiter on multiple columns so output can be 
11,K234,Prashant
11,K235,Pulkit

 

Interesting puzzle, we will have a look at it 

Hi.

I have created a working example for you

Please see attached file.

 

Here are some screenshots as well

Hi Peter,

Thanks for posting the solution , it's nice & elegant & scalable. 

I tested this with 4 fields and works absolutely fine.

Thank You !