You can use Transpose to change the data around as you want it.
Highlight all the data including headings, then click <copy. Move the
cursor to a blank area of the sheet below your existing data, then Edit
| Paste Special | Transpose (click) then OK and <Esc.

This should do what you want - you can then delete your original data.

Hope this helps.

Pete