I want to reverse the rows into columsn and vice versa from a mysql table.

I'm quite curious why you want to do such a thing - care to tell me? I'm hard pressed to find a use case for it. (It could also be an XY Problem)

I suggest you search for mysql export to csv. You can likely change the delimiter to a tab if necessary.