Split a record ( in a row) and make it as new row

Hi All,

The following is the scenario

id name
--------------
1 William;Johnson
2 Azim;Abdul
3 Grasim
.
.
etc....

I need the following output

id name
--------------
1 William
1 Johnson
2 Azim
2 Abdul
3 Grasim
.
.
..etc

Please tell me the way to achieve the solution.

Thanks in advance!!!!

Hi All,

Record is splitted by ';'. I need to handle the special character and make the ';'-separated data in to rows

Thanks!!!

awk -F';| ' '{for(i=2;i<=NF;i++) print $1,$i}' file