Copy columns to matrix

Data > Copy > Columns to Matrix

Complete the following steps to copy data from columns in the worksheet into a matrix.

In Copy from columns, enter the columns to copy (for example, C1 C2 C3).
Under Store Copied Data, in In current worksheet, in matrix:, enter the matrix to copy the data into, for example, M1.
To include a name for the matrix in addition to the matrix number, select Name the matrix containing the copied data.
Tip
To name or rename a matrix, use the NAME session command. For example, to name the matrix M1 "My Matrix", enter the following at the command prompt: NAME M1 "My Matrix".
To specify the rows from the columns to include or exclude, click Subset the Data and do the following:
1. Under Include or Exclude, specify whether to include or exclude rows from the copied columns.
2. Under Specify Which Rows to Include/Exclude, select one of the following:
  - All rows: Include all rows (available when you chose Specify which rows to include).
  - No rows: Exclude no rows (available when you chose Specify which rows to exclude).
  - Rows that match: Include or exclude rows that match the condition. Click Condition to enter the conditional expression. For more information, go to Create a formula with the Calculator.
  - Brushed rows: Include or exclude rows that correspond to brushed points on a graph.
  - Row numbers: Include or exclude the specified rows. Enter individual row numbers or ranges of row numbers. Use a colon (:) to denote an inclusive range. For example, to specify rows 4, 7, 11, 12, 13, and 14, enter 4 7 11:14.
Click OK in each dialog box.