How to apply transpose method in MYSQL, Getting rows as collumns
As yu will have different evaluators ver the time a dynamic approach is called for
if you have only a static, you can select the variable @sql and get ten result of the dynamc query


CREATE table Toy_ideas  (IDEA int, COMMENTS varchar(50), EVALUATOR_ID int)




INSERT INTO Toy_ideas VALUES(1,'coment1',1),
(1,'coment2',2),
(1,'coment3',3),(1,'coment4',5),
(2,'coment5',2),
(2,'coment6',4),(2,'coment7',5),
(3,'coment8',2),(3,'coment9',5)




SELECT 
  GROUP_CONCAT(DISTINCT
    CONCAT(
      'MAX(IF(EVALUATOR_ID = ',
     EVALUATOR_ID,
      ', `COMMENTS`,NULL)) AS `',
      CONCAT('EVALUATOR ',EVALUATOR_ID), '`'      
    )
    ORDER BY EVALUATOR_ID
  ) 
  INTO @sql
FROM Toy_ideas; 
SET @sql = CONCAT('select IDEA,',@sql,' from Toy_ideas
group by `IDEA`');

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


IDEA | EVALUATOR 1 | EVALUATOR 2 | EVALUATOR 3 | EVALUATOR 4 | EVALUATOR 5
---: | :---------- | :---------- | :---------- | :---------- | :----------
   1 | coment1     | coment2     | coment3     | null        | coment4    
   2 | null        | coment5     | null        | coment6     | coment7    
   3 | null        | coment8     | null        | null        | coment9    




db&lt;&gt;fiddle here