If you want to have a copy of a given column, you may want to duplicate that column.
You will duplicate two columns and use them as a base for recreating the email addresses.
- Click the column you want to duplicate, first_name in this example.
- Click the menu icon or right-click the column to open the contextual menu.
Click Duplicate column.
A copy of the column, first_name_copy, is created with the same data as the original.
- Repeat these actions to duplicate the last_name column.
The two columns are duplicated. The information contained in those two columns will be used to create the local part of the email addresses you want to create.