break up excel columns into rows

i am having a problem with an export from one system I have here and then importing it into another.  I have an excel sheet that currently has a few columns with information which i need to create something to automatically break the columns up into rows.  to explain Column A contains a persons name then column b, c, etc contains values pertaining to the person.  what i need to do is change this to a format where for each value in a column it creates a separate line giving the persons name, then a value, then the figure in the column.  but to complicate things the value wont be the column name it will be something else but will always be the same value


above shows what i have which is the top table and what i need which it the bottom table

any help would be greatly appreciated.