If you want to keep the data of a duplicate column instead of deleting it, you can merge the two duplicate columns using the 'Merge Cells' feature. Select both the duplicate columns, right-click and select 'Format Cells'. You can choose the 'Merge Cells' option on the Alignment tab. This method will combine the contents of both columns into a single cell and keep the original data.