How to transpose rows to column

Discussion in 'MySQL' started by neilfurry, Jun 6, 2021.

  1. #1
    hi,

    can you help me transpose this table:

    upload_2021-6-7_10-18-51.png

    into this output in mysql

    upload_2021-6-7_10-19-57.png

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

    Thank you in advance.
     
    neilfurry, Jun 6, 2021 IP