The transpose utility converts a column of data to a row of data and vice versa.
To use the utility, select Data > Transpose. In the transpose dialog, select whether you want to transpose a column into a row, or transpose a row into a column. Enter the column or variable name as well as the row number in the corresponding text boxes.