this is my input dataset.
ID Passed Subjects
101 Yes Math,English
101 Yes English,Physics,Chemistry
102 Yes Math,English
102 Yes English,Physics,Chemistry
I need the output like below
ID Math English Physics Chemistry
101 Yes Yes Yes Yes
102 Yes Yes Yes Yes
New contributor
Dillip Nayak is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.