|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
将字段名改了一下,
表格转换.rar
(52.25 KB, 下载次数: 10)
SELECT 品名,款号,色号,39 as 尺码,三九 as 数量 from [sheet1$] union all SELECT 品名,款号,色号,38 as 尺码,三八 as 数量 from [sheet1$] union all SELECT 品名,款号,色号,40 as 尺码,四零 as 数量 from [sheet1$] union all SELECT 品名,款号,色号,41 as 尺码,四一 as 数量 from [sheet1$] union all SELECT 品名,款号,色号,42 as 尺码,四二 as 数量 from [sheet1$] union all SELECT 品名,款号,色号,43 as 尺码,四三 as 数量 from [sheet1$] union all SELECT 品名,款号,色号,44 as 尺码,四四 as 数量 from [sheet1$] union all SELECT 品名,款号,色号,45 as 尺码,四五 as 数量 from [sheet1$] |
|