Query to get column names in a table

[access]

Hi,

I have a table "Student" with fields and entries as below

StudentName Year Class Subj1 Subj2 Subj3

I want to write a query to display the list of entries as below

StudentName Year Class Course Marks
... ... .... Subj1 <Value in Subj1 record>
... ... .... Subj2 <Value in Subj2 record>
... ... .... Subj3 <Value in Subj3 record>

ie. I want to get the column names from the table. Can any one help me out in this regard. Thanks.

[RuralGuy]

In a normalized table the records would look more like what you need than what you have. Repeating fields is a dead giveaway. Any chance to restructure that table?