Hi all, I am facing a problem of separating a single row into multiple rows. My original data is as following: student id | year_code ---------------------------- 1111 | 1213 ---------------------------- 1111 | 1314 ---------------------------- 1112 | 1213 ...... I want to change 1213 into 201280,201310 and 201350, i.e, change the first row 1111|1213 to 1111 |201280 ----------------- 1111 |201310 ----------------- 1111 |201350. Is there any code I can use to obtain the result I want? Thank you!
... View more