I would like to merge some custom fields in my database. I have a set of custom fields and in this set i have a custom field with multiple options, I will like now to merge some option fields for this custom field.
example: option field A = tomato|tomato , option field B = apple|apple , option field C = fruit|fruit ,
I want to merge A and B to C, note that both A, B and C have data.
Is this possible and how can i accomplish this without loosing any data? Civi version 4.5.5 and Drupal