Split multiple values from with in a Column

[raadwiptec]

I have an excel file source .. Few of the columns as below , One of the Fields -Code has multiple values within it and 

CertificateNumber | Amount | Code 

10099876 |100.52| 1-H2;2-L2

10099887 |83.92| 1-K2;2-GC;3-RA

10099765 |98.23| 1-9;2-8E

Output Required: The Split needs to be done.

CertificateNumber | Amount | Code 

10099876 |100.52| H2

10099876 |100.52| L2

10099887 |83.92| K2

10099887 |83.92| GC

10099887 |83.92| RA

10099765 |98.23| 9

10099765 |98.23| 8E

Thanks for the suggestions

[Saravanan_Desingh]

So, basically ..

If you have 1&2, then 1-50;2-50

If you have 3, then 1-33.33;2-33.33;3-33.33

If you have 4, then 1-25;2-25;3-25;4-25

If you have 5, then 1-20;2-20;3-20;4-20;5-20

Like it goes?

[raadwiptec]

Thanks toufiq. It gives the expected results.

[raadwiptec]

Yes but only if  in such scenario 1-25; 2-30;3-30 now we have 85 which need to be 100. we need to calculate to get it distributed equally to 100