How can I list data horizontally (across the worksheet) by using Excel template?

Hi All,
I'm using Excel template to develop my report. By default, the data will list down the sheet (i.e. from top to bottom).
I need to show the data horizontally (i.e. from left to right), do anyone can tell how I can achieve this?

Example:
Default
Column A    Column B
Pen             10
Ruler           30
Book           20

Now I want it show horizontally
Pen       Ruler       Book   ...
10         30           20


Thanks!

Kin