Copy columns to matrix

Data > Copy > Columns to Matrix

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

  1. In Copy from columns, enter the columns to copy (for example, C1 C2 C3).
  2. Under Store Copied Data, in In current worksheet, in matrix:, enter the matrix to copy the data into, for example, M1.
  3. To include a name for the matrix in addition to the matrix number, select Name the matrix containing the copied data.

    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".

  4. 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.
  5. Click OK in each dialog box.
By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy