关于复杂行列转换的问题.急!

[jsy2005]

有如下表

A B C D E
1 2 1 4 AA
2 3 1 2 BB


希望转换成如下形式

AA BB
A 1 2
B 2 3
C 1 1
D 4 2


请问如何实现

[i9988]

select 'A' as E,max(case when E='AA' then a end) as AA,max(case when E='BB' then a end) as BB from tablename
union all
select 'B' as E,max(case when E='AA' then b end) as AA,max(case when E='BB' then b end) as BB from tablename
union all
select 'C' as E,max(case when E='AA' then c end) as AA,max(case when E='BB' then c end) as BB from tablename
union all
select 'D' as E,max(case when E='AA' then d end) as AA,max(case when E='BB' then d end) as BB from tablename

[dawugui]

楼上正解