values of column displaying in rows

Hi All,

I have some values in the column and i want those values to be displayed in rows now.

Example:

In the Excel sheet the data is in the form,
Column1 Column2 Column 3
TASK_TYPE NE_TYPE ADC_PARAM_ORL

I want in the format,
Column1
TASK_TYPE
NE_TYPE
ADC_PARAM_ORL

Please let me know the solution.

First, insert a new column at the left side of the sheet.

Then copy the row items

Go to the new first column and go to Edit|Paste Special select Transpose.

Click Ok.

You can now delete the row items.