我需要你们专业的建议来部分转置这个MS SQL表:
| Term | Listening | Reading | Speaking | Writing |
| AC1 | 12 | 15 | 18 | 13 |
| AC2 | 17 | 14 | 9 | 12 |
转化为:
| Term | Comp | Score |
| AC1 | Listening | 12 |
| AC1 | Reading | 15 |
| AC1 | Speaking | 18 |
| AC1 | Writing | 13 |
| AC2 | Listening | 17 |
| AC2 | Reading | 14 |
| AC2 | Speaking | 9 |
| AC2 | Writing | 12 |
如果您能提供建议,将不胜感激。先在这里谢过了。