# Specify cells for new column

The Specify cells for new column dialog is used for specifying the conditions for automatically generating a new column from an existing one. It is accessed from the Column page in the File Wizard : Transform dialog.

* Cells and Columns:
  * Source Column: Sets the column number from which cell values should be copied.
  * Cells from these rows: Opens the Specify Row Condition dialog where it is possible to set the row condition.
  * Target Column: Specifies the number of the target columns.
* Advanced Options:
  * Replace Null Value with Previous Value: Fills empty cells with the value in the cell above.
  * Delete Source Row: Deletes the source row after copying its content.