If you want to do this manually try this.

  • Select the range of data (B5:B30)

  • Edit | Copy

  • Select the first cell of where you want to paste to (C5)

  • Edit | PasteSpecial | Transpose