Variable old_ID may include several names for each name in new_ID. I want to have only one name in old_ID for each name in new_id by separating names in old_id into several rows as the following. Could you show me how to do so? Thank you so much! Old_ID New_ID P006 B01002 P006A B01002A PCT003 B02005 P038 B05002 P047, P052 B08006 P016, P007, P023, P027, P030 B11001 P024, P008 B11002 P024A, P008A, B11002A Old_ID New_ID P006 B01002 P006A B01002A PCT003 B02005 P038 B05002 P047 B08006 P052 B08006 P016 B11001 P007 B11001 P023 B11001 P027 B11001 P030 B11001 P024 B11002 P008 B11002 P024A P008A P008A P008A
... View more