Convert rows into columns MySQL DataBase
SELECT  Table1.*, 
    (SELECT Table2.Columna2 WHERE Table2.Columna4='ALTA') AS Name1,
    (SELECT Table2.Columna2 WHERE Table2.Columna4='ATENCION') AS Name2
    (SELECT Table2.Columna2 WHERE Table2.Columna4='CLIENTE') AS Name3
FROM Table1 INNER JOIN Table2 ON Table1.ID = Table2.FK_ID


is what you want.

But there are other ways to achieve this.