Pivot worksheets based on switching the columns and rows in a worksheet. For example, if a worksheet has Subject, Parameter, and Parameter Value columns, and each parameter was to be placed in its own column, this object can transpose the worksheet based on selections made in the Worksheet Mappings panel.
The Pivot Worksheet object is primarily used to unstack, or pivot, stacked datasets like the Final Parameters output worksheet from a PK or NCA model.
Use one of the following to add the worksheet object to a Workflow:
Right-click menu for a Workflow object: New > Data Management > Pivot Worksheet.
Main menu: Insert > Data Management > Pivot Worksheet.
Right-click menu for a worksheet: Send To > Data Management > Pivot Worksheet.
To view the object in its own window, select it in the Object Browser and double-click it or press ENTER. All instructions for setting up and execution are the same whether the object is viewed in its own window or in Phoenix view.
Mappings panels identify how input variables are to be used. Map the data by dragging the dataset from the Data folder to the Setup tab or use the 
icon in the Setup tab.
Once a dataset is mapped, use the option buttons in the Mappings panels to assign the columns in the dataset to the appropriate context associations. Required context mappings are colored orange.
Column Header: Data type to use for creating the column headers in the output worksheet. Only one data type can be mapped to this context.
Values: Data type to fill the columns for each column header. Only one data type can be mapped to this context.
Row Header: Data types to use for defining the rows in the pivoted worksheet. Multiple data types can be mapped to this context. Each combination creates a unique set of profiles that are used to order the output worksheet rows.
Unit: Source data column containing unit information. When checked, the units become part of the column header upon pivoting. If incompatible units (including blank units) are found in the unit column, then the pivot will not be able to be performed until these inconsistencies are resolved or units are unmapped.
Carry: Variable(s) to copy to the output worksheets.
Attribute: Data types to combine with the data type mapped to Values to create additional column headers.
Select the Results tab to view the output. The object generates one worksheet and one text file.
Results: The pivoted worksheet.
Settings: Text file containing input worksheets used and the options selected.