SELECT 
    t1.team,
    MAX(IIF(t2.rn=1, t2.user, NULL)) AS Personel_1,
    MAX(IIF(t2.rn=2, t2.user, NULL)) AS Personel_2,
    MAX(IIF(t2.rn=3, t2.user, NULL)) AS Personel_3,
    MAX(IIF(t2.rn=4, t2.user, NULL)) AS Personel_4
FROM tablo1 AS t1
INNER JOIN 
    (SELECT team, user, 
            (SELECT COUNT(*) FROM tablo1 AS t2 
             WHERE t2.team = t1.team AND t2.id <= t1.id) AS rn
     FROM tablo1 AS t1) AS t2
ON t1.team = t2.team
GROUP BY t1.team;