SQL - Pasar fila a columna de forma dinámica

SET @cols = '';

SELECT

    GROUP_CONCAT('MAX(CASE WHEN local = ''', local, ''' THEN total_vendido ELSE 0 END) AS `', local, '`')

INTO @cols

FROM

    (

        SELECT

            local

        FROM

            tabla

        GROUP BY

            local

    )

    x;

SET @query = CONCAT('SELECT producto, ', @cols, ' FROM tabla GROUP BY producto');

PREPARE stmt

FROM

    @query;

EXECUTE stmt;

DEALLOCATE PREPARE stmt;

create or replace procedure sp_fila_columna()

begin

declare V_sql varchar(100);

set V_sql = SELECT

  GROUP_CONCAT(DISTINCT CONCAT('max(case when nombre_local = ''',nombre_local,''' then total_vendido end) as '', nombre_local, '''))

FROM   (select cod_producto, nombre_producto,nombre_local from rep_venta_productos) as d;

PREPARE stmt FROM V_sql;

EXECUTE stmt;

DEALLOCATE PREPARE stmt;

end;

$$