I have just imported an excel table to SharePoint List.
The "Title" field is text by default and I have values "Mr", "Mrs", "Ms", ... in it.
I need "Title" field to be choice instead.
I know that I can't just change the "Title" field type as for other fields.
If I then create another field "TitleChoice" with all my choices, is there an easy way to update all existing items, like:
item["TitleChoice"] = item["Title"]
I have more than 5000 items in my List.