如何将不同的列值显示在单个列中不同列和不同列的值中？

DAY       PERIOD     YEAR   SEC      TeacherID

Monday         1        3     C         100010
Monday         2        3     C         100011
Tuesday        1        3     C         100011
Tuesday        2        3     C         100010


Display for TeacherID 100010

Period      Monday     Tuesday
     1         3,C         
     2                     3,C 
DAY       PERIOD     YEAR   SEC      TeacherID