交叉表并行

Question

如何把
------------------------------------------   
 编号         A1    A2   A3  A4    A5
ZN20040326004  WUB04                                    
ZN20040326004                      WXS03
ZN20040326004             WXS05
------------------------------------------
改为以下方式
-----------------------------------------
     编号        A1     A2   A3  A4    A5
ZN20040326004  WUB04      WXS05      WXS03
-----------------------------------------

Answer 1

如果确定每个编号组，A1,A2....各列都只有一个值select 编号, max(a1),max(a2),max(a3),max(a4),max(a5)
from tablename
group by 编号

Answer 2

非常抱歉，说得不清楚，A1..A5没列都可以是多值的 如------------------------------------------       
  编号                   A1         A2       A3     A4         A5 
ZN20040326004     WUB04                                                                         
ZN20040326004                                             WXS03 
ZN20040326004                           WXS05 
ZN20040326004                                             WXS05 
------------------------------------------ 
改为以下方式 
----------------------------------------- 
编号                 A1           A2       A3     A4         A5 
ZN20040326004     WUB04             WXS05             WXS03 
ZN20040326004                                         WXS05 
-----------------------------------------