Thanks for your replies, think I found what I was doing wrong. I should have selected All and then transposed. Worked fine after that.

Thanks again.