I have data like as below
Name |
Subject |
Grade |
John |
Eng,Math |
A,B |
Clarice |
Eng,Science |
O,B |
Kennedy |
Math |
O |
Kevin |
Eng |
A |
How do i generate new rows based on the column which has , on them
Name |
Subject |
Grade |
John |
Eng |
A |
John |
Math |
B |
Clarice |
Eng |
O |
Clarice |
Science |
B |
Kennedy |
Math |
O |
Kevin |
Eng |
A |