🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

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

Sort by:
1 - 1 of 11