I am new to SharePoint. I need to modify some existing column names in List . I also need to change the choices names eg:
Column Name : Type choices : Car, Bus, Truck
New Column name : Category Choices : Two Tires, Four Tires, six tires
In above without deleting Type i renamed it to Category and removed old choices and added new choices. In this case will i be able to retain the data that is store for old choices like if there is a record with Car type then when i make change will the Category still have Car choice or all the data will be lost?