Re: [Query help] Table transformation

[Rick James]

Is this any closer...

SELECT key,
       GROUP_CONCAT(eng SEPARATOR '') AS engName,
       GROUP_CONCAT(swe SEPARATOR '') AS sweName
    FROM
       ( SELECT key, name AS eng, CAST(NULL AS CHAR) AS swe
            FROM tbl
            WHERE locale = 'eng'
       )
       UNION
       ( SELECT key, CAST(NULL AS CHAR), name
            FROM tbl
            WHERE locale = 'swe'
       )
    GROUP BY key;

1. The inner SELECTs put the fields in the 'right' columns.
2. The UNION gets the eng and swe rows ready for the outer SELECT.
3. GROUP BY collects the pair (or single) rows.
4. The GROUP_CONCAT (I hope) finishes combining or leaving null.

COALESCE is another function to investigate.