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.