MySQL 5.7

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE mytable (
  id INT,
  text VARCHAR(50),
  language VARCHAR(50)
);

INSERT INTO mytable VALUES
(1,'deutscher text','german'),
(2,'english text','english');
SET @sql := NULL;

SELECT GROUP_CONCAT(CONCAT('MAX(CASE WHEN language="',language,'" THEN text END) AS "',language,'"')) INTO @sql
FROM mytable;

SELECT CONCAT('SELECT ',@sql,' FROM mytable;') INTO @sql;

PREPARE stmt FROM @sql;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;


german
english


deutscher text
english text


SELECT @sql;


@sql


SELECT MAX(CASE WHEN language="german" THEN text END) AS "german",MAX(CASE WHEN language="english" THEN text END) AS "english" FROM mytable;