Hi Excel gurus,
I have a problem as below
initial data
stud nbr | stud name | grade | subjects
1 abc 10 maths,physics,chemistry
2 pqr 20 maths,computers
my data should be repeated based on subjects
expected data:
stud nbr | stud name | grade | subjects
1 abc 10 maths
1 abc 10 physics
1 abc 10 chemistry
2 pqr 20 maths
2 pqr 20 computers
I have checked couple of forums and could see macros. I want to know and understand how this could be done with the help of a formula. Please help me. Thanks
Bookmarks