以下是示例代码，您可以修改它，因为它不包括您可能拥有的所有可能的列。我使用field_orig列而不是field_sgq列，因为它在屏幕截图中显示的示例数据中具有空值。

DROP TABLE IF EXISTS TEMPTable;
CREATE TEMPORARY TABLE TEMPTable
(
    datasource TEXT,
    holdeid TEXT
    ,depth_from NUMERIC
    ,depth_to NUMERIC
    ,field_orig TEXT
    ,field_sgq TEXT
    ,pvalue TEXT
);

INSERT INTO TEMPTable VALUES ('wadl4_a117888','WRVAC065',0.00,3.00,'projectcode','project','Yilgarn'),
('wadl4_a117888','WRVAC065',0.00,3.00,'weath','Weathering','5'),
('wadl4_a117888','WRVAC065',0.00,3.00,'clr1','Lith1_Color1','BN'),
('wadl4_a117888','WRVAC065',0.00,3.00,'clr2','Lith1_Color2','OR'),
('wadl4_a117889','WRVAC065',0.00,2.00,'projectcode','project','YilgarnT'),
('wadl4_a117889','WRVAC065',0.00,2.00,'weath','Weathering','2'),
('wadl4_a117889','WRVAC065',0.00,2.00,'clr1','Lith1_Color1','BNT'),
('wadl4_a117889','WRVAC065',0.00,2.00,'clr2','Lith1_Color2','ORY');

SELECT * FROM crosstab('select datasource,holdeid,depth_from,depth_to,field_orig,pvalue from TEMPTable',  $q$ values ('projectcode'),('weath'),('clr1'),('clr2') $q$)
             AS ct (datasource TEXT,
    holdeid TEXT
    ,depth_from NUMERIC
    ,depth_to NUMERIC,projectcode TEXT, weath TEXT, clr1 TEXT, clr2 TEXT);