1. Home
  2. Duplicating a Column

Duplicating a Column

You can insert a new column by duplicating an existing one. You can also duplicate multiple columns within a spreadsheet.

Duplicating a single column

  1. Place the cursor anywhere in the column you want to duplicate then from the menu select Spread | Column | Duplicate.
    OR
    Edit | Column | Duplicate.
  2. Set options as required then click OK.

Column Select the name of the column you want to duplicate.
New column name Rename the new column. The new name must not matching any existing column names.
Sort factor levels/labels Any text or variate columns that are duplicated as factors will have their levels/labels sorted in ascending order.
Insert missing values in rows excluded by filter Any rows that have been excluded by restricting or filtering the data will have missing values inserted.
Create as Lets you convert the new column to a different data type.

Duplicating multiple columns

  1. Hold the keyboard Ctrl key and click the column headers with the mouse to select them.
  2. From the menu select Spread | Column | Duplicate.
  3. Set options as required then click OK. The dialog below will re-open to enable you to set options for each column in turn.

Column Select the name of the column you want to duplicate.
New column name Rename the new column. The new name must not matching any existing column names.
Sort factor levels/labels Any text or variate columns that are duplicated as factors will have their levels/labels sorted in ascending order.
Insert missing values in rows excluded by filter Any rows that have been excluded by restricting or filtering the data will have missing values inserted.
Create as Lets you convert the new column to a different data type.

Updated on February 28, 2019

Was this article helpful?