How to view a row in a table as column

Question

let's say I have a row that contains Id(primary key) name regno maths(marks) language computer total it will be saved in a row but I want to view in such a way that id(primary key) regno a particular subject (lets say maths) and next column should contain the same but instead of maths language (marks) should be there