怎么把这三列数据统计在同一个数据透视表上？

yy9739852

受理1与受理1提成是对应的

消灭零公里

规范表格的记录方式才是正事，非要这么记录的话就用PQ处理一下吧

q1579398897

SQL：

1. SELECT 受理1 AS 受理,受理1提成 AS 提成,"受理1" AS 标记1,"受理1提成" AS 标记2 FROM ['Sheet2 (2)$']
   
2. UNION ALL
   
3. SELECT 受理2 AS 受理,受理2提成 AS 提成,"受理2" AS 标记1,"受理2提成" AS 标记2 FROM ['Sheet2 (2)$']
   
4. UNION ALL
   
5. SELECT 受理3 AS 受理,受理3提成 AS 提成,"受理3" AS 标记1,"受理3提成" AS 标记2 FROM ['Sheet2 (2)$']

复制代码

yy9739852

q1579398897 发表于 2022-3-8 10:42
SQL：

太厉害了，怎么做出来的？

yy9739852

消灭零公里 发表于 2022-3-4 16:31
规范表格的记录方式才是正事，非要这么记录的话就用PQ处理一下吧

感谢，但是我不懂PQ