1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

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:
    SEMrush
    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
    SEMrush