In order to have a copy of the original data without having to create a new column and manually copy the data, you can simply duplicate a column.
Before working on the data, you will create a new column to receive the consolidated numbers.
- Click the column you want to duplicate, Mobile 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, Mobile_Copy, is created with the same data as the original.
The Mobile column is duplicated and can now receive the consolidated data.