Here is my situation. I have uploaded the data to the table but have changed my mind about a column being data type choice. (food type)
If the person doesn't like the (food type) options I made I am a bit stuffed so I am going to make a separate (food type) options table and control what they can input or search for based on this other table I can easily add to or take away from. And make the main table (food type) column text.
However I already have all the data in the main table. How do I go about this change?
Is there a formula I can do for a calculated column to convert those values to text and delete the old column?
Or
Do I create a new text column then upload the data there using the key column and delete the old column?
Are either of those options possible?
