|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
所用代码:- select * from (select f1&f11 as 类别,f2 as 速率,f3 as 成员个数,f4 as 网元名称 from [sheet1$a3:k8] union all select f1&f11,f2,f3,f5 from [sheet1$a3:k8] union all select f1&f11,f2,f3,f6 from [sheet1$a3:k8] union all select f1&f11,f2,f3,f7 from [sheet1$a3:k8] union all select f1&f11,f2,f3,f8 from [sheet1$a3:k8] union all select f1&f11,f2,f3,f9 from [sheet1$a3:k8] union all select f1&f11,f2,f3,f10 from [sheet1$a3:k8]) where 网元名称 order by 类别
复制代码
过程动画
|
|