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 menu icon 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.