|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
SELECT * FROM (select 账套,所属期间,分支公司代码,产品代码,"PR1" as 事项代码,渠道代码,PR1 as 金额 from [RSV (2)$a1:k17] UNION ALL select 账套,所属期间,分支公司代码,产品代码,"PR2" as 事项代码,渠道代码,PR2 as 金额 from [RSV (2)$a1:k17] UNION ALL select 账套,所属期间,分支公司代码,产品代码,"PR3" as 事项代码,渠道代码,PR3 as 金额 from [RSV (2)$a1:k17] UNION ALL select 账套,所属期间,分支公司代码,产品代码,"PR4" as 事项代码,渠道代码,PR4 as 金额 from [RSV (2)$a1:k17] UNION ALL select 账套,所属期间,分支公司代码,产品代码,"PR5" as 事项代码,渠道代码,PR5 as 金额 from [RSV (2)$a1:k17] UNION ALL select 账套,所属期间,分支公司代码,产品代码,"PR6" as 事项代码,渠道代码,PR6 as 金额 from [RSV (2)$a1:k17] ) WHERE 金额 is not null order by 1 desc,2
|
评分
-
1
查看全部评分
-
|