I'm a new administrator trying to catch up and make some change to our existing system and clean up some mistakes from the past. Our previous administrator had created a single field and placed it on multiple forms despite it needing two separate fields.
Is there a straightforward way to separate the existing data for this field into two and create two entirely separate entities?
I would think the best course of action may be to export the data, manually separate, then create a new field and upload the data accordingly?
The issue is this isnt a required field as it doesn't always apply.
Any insight would be helpful.
