Transpose rows and columns

Transposing rows and columns

This page explains the Transpose analysis, which transposes an entire table, creating a new results table. Another way to transpose is to copy selected data, and then paste transpose.

Each row of Y values becomes one column (data set) in the results table. The first row becomes the first data set, the second row becomes the second data set, etc. You may not transpose a data table with more than 104 rows, because Prism cannot create a table with more than 104 columns.

The column and row titles in the results table are determined by your choices in the dialog.

Don't forget to check the option box if you want to create a new graph from the transposed data.