How to transpose rows to column

hi,

can you help me transpose this table:

View attachment 264846

into this output in mysql

View attachment 264847

Where p1, p2 …. is the number of panelist which is undetermined/dynamic.

Thank you in advance.