i have a column bfi_name and values like this enter image description here

i want to extract this table into this format enter image description here

how can i do this in mysql?

  • 1
    Output formatting, especially this complex, is better done in an application language than in SQL. – Rick James Feb 2 at 5:58

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.