How to create new Rows data based on split character values in Column data

User: "Vanlal"
New Altair Community Member
Updated by Jocelyn
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

Find more posts tagged with