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 white arrow 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 column will be used to create the local part of the email addresses you want to create.