Sorry if my syntax is a bit off here, I'm very new to Sharepoint.
We have a document library in Sharepoint with a Managed Metadata column for the department (we have a list of departments in the Term Store library). The organisation has restructured recently, and we need to change the Department column to reflect the new department names. Each of the old department names does map to a new department name, but its not a 1:1 thing (for eg OldDept1 and OldDept2 may now both be NewDept1), so we need to do some kind of mapping procedure.
What would be the best way to go about this? We thought about adding a calculated column with a formula to do the mapping, but that won't stand up for future additions.