Adding a Column Based on This Column

Use this function to add a new column by editing an existing column.

Procedure

  1. From a column menu, click Edit column > Add column based in this column.
  2. In the New column name field, enter a name for the new column.
  3. Optional: To override an existing column with the same name, select the Override if column exists check box.
  4. Optional: In the Expression field, enter a regular value.
  5. Select from the following options to handle errors in a cell:
    • Set to blank: Set the cell to blank.
    • Store error: Store the error in the cell.
    • Copy value from original column: Copy the value from the original column.
  6. Click OK.