P110 Transpose Sheet Data

 

 

 

/P#

Meaning

Extra Parameters: /1{Parameter1} … /n{Nth Parameter}

110

Transpose sheet. Convert rows to columns and columns to rows.

/1 = sSheet – worksheet to be transpose

 

This special process allows you to search for text within cells and replace it with other text.

Special Parameters Described in Detail

/1{sSheet} Name of the sheet to Transpose. Required.

Examples:

EXAMPLE 1 Transpose Sheet1 of Courses.XLS