Mass Data Table in to Workable Format!

Hi All,

New to the forum, hoping you'll be able to solve a problem I have been stuck on for weeks!! I have tried google, youtube etc but I don't think i'm able to search the correct terms for what I'm wanting to do... which is how I came across you guys and girls!!

I get this data on a weekly basis from our payroll department (all personal data has been removed from the file for this query).
I'm wanting to make the format cleaner, so I can then use the data for other reports. Currently the table is in a horizontal format, with 70+ headers meaning I have to transpose the headers and then individually look up the 160 employees to get the data in a tabular format, I can use the match or lookup functions, but this means individually changing the lookup row for each employee and can also do the old fashioned copy and paste, but again I would need to repeat this 100's of times to get the data aligned, it's do-able but massively time consuming.

The personal data columns aren't needed, I just need the financial data starting from column T (employers NI) to Column CM (trading bonus)

example of my explanation/idea below;

Current state;

Salary Tax Bonus Car Allowance Pension
Person A X X X X X
Person B X X X X X
Person C X X X X X

Goal


Person A Salary X
Person A Tax X
Person A Bonus X
Person A Car X
Person A Pens X
Person B Salary X

etc...

OR

Person A Salary X
Person B Salary X
Person C Salary X
Person A Tax X

etc.

I am on excel 2013 and if an additional extension was needed I would need approval from IT, so i'm hoping there is something already set up, a formula or a macro that I can do this with.
If this doesn't make sense please let me know and i'll try and put a bit more info together!