Как перевести строки в в столбцы?

SELECT * FROM crosstab
(
  'SELECT shop, user, depatrment, subject
    FROM   my_table
    ORDER  BY 1, 2, 3',
  'SELECT DISTINCT description  FROM my_table ORDER BY 1'
)
AS
(
       shop text,
       USER text,
       subject text,
       "Administrator" VARCHAR,
      Employee VARCHAR,
      "Consultant" text);

SELECT shop,"user","Administrator","admim_value","Employee","emp_value","Consultant","consul_value"
FROM 
    crosstab(
        'SELECT shop, "user", department, subject FROM my_table ORDER  BY 1, 3, 2',
        'SELECT DISTINCT department  FROM my_table ORDER BY 1'
    ) r0 (shop text,"user" text,"Administrator" text,"Employee" text,"Consultant" text)
    LEFT JOIN crosstab(
        'SELECT shop, "user", department, "value" FROM my_table ORDER  BY 1, 3, 2',
         'SELECT DISTINCT department  FROM my_table ORDER BY 1'
    ) r1 (shop text,"user" text,"admim_value" INTEGER,"emp_value" INTEGER,"consul_value" INTEGER)
    USING(shop,"user")

SELECT  r.shop,r."user",
        admin.subject "Administrator", admin."value" admin_value,
        empl.subject "Employee",empl."value" "emp_value",
        consul.subject "Consultant",consul."value" "consul_value"
FROM    (SELECT DISTINCT shop,"user" FROM my_table ) r
        LEFT JOIN my_table admin ON (r."user" = admin."user" AND r.shop=admin.shop AND admin.department='Administrator')
        LEFT JOIN my_table empl ON (r."user" = empl."user" AND r.shop=empl.shop AND empl.department='Employee')
        LEFT JOIN my_table consul ON (r."user" = consul."user" AND r.shop=consul.shop AND consul.department='Consultant')

SELECT shop,"user","Administrator","admim_value","Employee","emp_value","Consultant","consul_value"
FROM 
    crosstab(
         'SELECT shop, "user", department, subject FROM my_table 
         WHERE department in (''Administator'',''Employee'',''Consultant'')
         ORDER  BY 1, 3, 2',
        'values (''Administator''),(''Employee''),(''Consultant'')'
    ) r0 (shop text,"user" text,"Administrator" text,"Employee" text,"Consultant" text)
    LEFT JOIN crosstab(
         'SELECT shop, "user", department, "value" FROM my_table 
         WHERE department in (''Administator'',''Employee'',''Consultant'')
         ORDER  BY 1, 3, 2',
        'values (''Administator''),(''Employee''),(''Consultant'')'
    ) r1 (shop text,"user" text,"admim_value" INTEGER,"emp_value" INTEGER,"consul_value" INTEGER)
    USING(shop,"user")

SELECT shop,"user","Administrator","admim_value","Employee","emp_value","Consultant","consul_value"
FROM 
    crosstab(
         'SELECT shop, "user", department, subject FROM my_table 
         WHERE department in (''Administrator'',''Employee'',''Consultant'')
         ORDER  BY 2, 1, 3',
        'values (''Administrator''),(''Employee''),(''Consultant'')'
    ) r0 (shop text,"user" text,"Administrator" text,"Employee" text,"Consultant" text)
    LEFT JOIN crosstab(
         'SELECT shop, "user", department, "value" FROM my_table 
         WHERE department in (''Administrator'',''Employee'',''Consultant'')
         ORDER  BY  2, 1, 3',
        'values (''Administrator''),(''Employee''),(''Consultant'')'
    ) r1 (shop text,"user" text,"admim_value" INTEGER,"emp_value" INTEGER,"consul_value" INTEGER)
    USING(shop,"user")
ORDER BY 1,2