Big Chemical Encyclopedia

Chemical substances, components, reactions, process design ...

Using Paste Special to Transpose Rows and Columns

USING PASTE SPECIAL TO TRANSPOSE ROWS AND COLUMNS [Pg.23]

First Copy the cells, then select a cell or range in which you want the transposed values to be placed. Choose Paste Special and check the Transpose box, then press OK. [Pg.23]

The transpose is obtained by using the worksheet function TRANS POSE (array) or the Transpose option in the Paste Special... menu command (see "Using Paste Special to Transpose Rows and Columns" in Chapter ) ... [Pg.189]

SEARCH

Column Use

Paste Special...

Rowing

Rows and Columns

Special Columns

Transpose