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.
