Have you tried the 'Edit / Paste Special / Transpose' function ?.
You'll need to Insert a new blank column A first off, to take the transposed headings. Then select the column headers in cells B1, C1, D1 etc, right click and choose Copy. Select cell A2, right click and choose Paste Special and click on the 'Transpose' check box, then OK. The column headers should now occupy cells A2, A3 ,A4 etc. Do the same with the old row headers (which would now be in cells B2, B3, etc), and Copy / Paste Special / Transpose these to overwrite cells B1, C1, D1, etc.