05-29-2016 10:24 PM - edited 05-29-2016 10:40 PM
I have the following data set where I want to bring all variables under one new variable. can someone please tell me how do i do that. Thanks.
ID Summer Fall Spring
ID Summer Fall Spring All_Courses
101 Math Math
101 English English
101 Physics Physics
05-30-2016 10:02 AM
This looks like some made up sample data. What is the underlying requirement?
From a data perspective, I would rather see the following outcome (after transposing):
ID Term Course
101 Summer Math
101 Spring English
101 Fall Physics