请教如何将表1的转到表2？

[查询1]  SELECT DISTINCT mc FROM B1

[查询2]  SELECT DISTINCT km FROM B1

[查询3]  SELECT TOP 2 B1.ljs/2 AS ljs FROM B1

[查询4]  SELECT 查询1.mc & 查询2.km & 查询3.ljs AS 名称, 0 AS 数值 INTO a FROM 查询1, 查询2, 查询3

[查询5] UPDATE a, B1 SET a.数值 = [B1].[ljs] WHERE (((a.名称)=[B1].[mc] & [B1].[km] & "2"))

[查询6] UPDATE a, B1 SET a.数值 = [B1].[bys] WHERE (((a.名称)=[B1].[mc] & [B1].[km] & "1"))

[查询7] TRANSFORM Sum(a.数值) AS 数值之合计 SELECT Left([名称],2) AS mc FROM a GROUP BY Left([名称],2) PIVOT Right([名称],2)

[查询8]  SELECT 查询7.mc, 查询7.甲1 AS bys1, 查询7.甲2 AS ljs1, 查询7.乙1 AS bys2, 查询7.乙2 AS ljs2, 查询7.丙1 AS bys3, 查询7.丙2 AS ljs3 INTO B2 FROM 查询7;