The Unstack Table menu option allows the user to "unstack" values from multiple rows into several columns in a row. It is the opposite of the "Stack" command. It can be accessed by going to: Table | Unstack.
Input Data Requirements
This command works on all “Table” objects, including Design Tables and Annotation Tables.
Step 1: Select the source table
The user will first be asked to choose the table to Unstack:
Step 2: Specify columns to split and group
The user is then presented with the "Unstack Table" window displaying "Columns in the table" box. This contains any columns in the dataset that can be used for the purposes of unstacking.
- Pick the Split by column, using the dropdown box. The Split by column determines the columns in the new Table.
- Select the Split columns which determines the factor(s) to be split (cell contents in the new table).
- (Optional) Select Group columns, that when combined with the Split column(s) will determine rows in the new table.
- Keep remaining columns: When checked, will ensure that any columns not used in the unstacking process (Split by, Split columns, Group columns) will be kept and brought over to the new table.
- Output table name: Name the newly created Table object.
A new table will be created in the Solution Explorer, unstacking the rows as defined in Step 2. Please refer to Example Usage for a specific case.
An example of the Unstack command is shown below. In the first picture, the table contains a Sample column (with 4 samples), an Intensity column, and a Gene column.
Using the Unstack function by specifying "Split by" Sample, "Split columns" Intensity, and "Group columns" Gene
The "Unstack" command converts the table into a new Table object with one column for each sample.