- SELECT 月份 as 地区,"2006年" as 年,"1月" as 月,[1月] as 数值 from [sheet1$a2:j7] union all SELECT 月份 as 地区,"2006年" as 年,"2月" as 月,[2月] as 数值 from [sheet1$a2:j7] union all SELECT 月份 as 地区,"2006年" as 年,"3月" as 月,[3月] as 数值 from [sheet1$a2:j7] union all SELECT 月份 as 地区,"2007年" as 年,"1月" as 月,[1月1] as 数值 from [sheet1$a2:j7] union all SELECT 月份 as 地区,"2007年" as 年,"2月" as 月,[2月1] as 数值 from [sheet1$a2:j7] union all SELECT 月份 as 地区,"2007年" as 年,"3月" as 月,[3月1] as 数值 from [sheet1$a2:j7] union all SELECT 月份 as 地区,"2008年" as 年,"1月" as 月,[1月2] as 数值 from [sheet1$a2:j7] union all SELECT 月份 as 地区,"2008年" as 年,"2月" as 月,[2月2] as 数值 from [sheet1$a2:j7] union all SELECT 月份 as 地区,"2008年" as 年,"3月" as 月,[3月2] as 数值 from [sheet1$a2:j7]
复制代码 |