[color=FF0000]竖表：[/color]
学号     姓名      科目       成绩
0414001  张三      语文       80
0414002  李四      语文       92
0414003  王五      语文       75
0414001  张三      数学       50
0414002  李四      数学       56
0414003  王五      数学       75
0414001  张三      英语       78
0414002  李四      英语       77
0414003  王五      英语       74

横表：
学号     姓名      语文    数学    英语
0414001  张三      80      50       78
0414002  李四      92      56       77
0414003  王五      75      75       74