How to convert rows into columns and columns in a row in MySQL?

Question

I have tried a lot of queries and saw a lot of videos and tutorials. I am little bit confused about it that " How and what type rows we can convert into columns? "

Answer 1

Some flavors of sql might have support for "pivoting" a table.
You need to clarify if you use mssql, mysql, postgresql, oracle...
https://stackoverflow.com/questions/13372276/simple-way-to-transpose-columns-and-rows-in-sql

Answer 2

that is not possible

Answer 3

Tibor Santa thank you. That's what I want to do.