What can be the best solution for the pipeline to deploy the solution successfully without losing the other column data?
Unfortunately not. There are other systems which rely on the internal name of that column to use that data.
You could leave the column in situ and just add another column ?
mmbr1606
22
Super User 2025 Season 1
stampcoin
17
ankit_singhal
11
Super User 2025 Season 1