you can copy the cells you want to transpose, then use Paste Special, check the Transpose box, click OK. That's it!