A number of data elements with a TEXT value type option set attached to them have data already collected. We want to assign a different option set (of number value type) to the same data elements. How can we make these changes and how will this affect the data that is already collected?
I saw a similar topic a few days ago, with almost the same question: Topic - 46987
So I think the approach will be the same - you would need to modify all of your data which has already been entered to match that of the new optionset.
I have read the topic you have suggested, Must the modification of data occur in the database? I exported the data in CSV format, but I think there is no way to change the data to match the new option set in the downloaded file.
When the CSV is ready with the required format and updated values, you’ll be able to import them using the Import / Export app. Using the app seems like the easiest solution other than the database.