Data layout between row and column

I do not know if this is possible ?

My data headers are by row and I need to switch them to columns. The data is held over 16 rows and also contains 2 blank header rows in the original data though I have put the correct column header in the output worksheet.

Can anyone help as I cannot secure the data in the format and the current foramt is not workable.

I have attached a test file to show how it looks and how I need it.

Thanks!