I've got a handful of content types that all use different fields to hold the same type of data. For instance,
Content Type A -- Field Name: field_type_a_user, Field type: Entity Reference
Content Type B -- Field Name: field_type_b_user, Field type: Entity Reference
Content Type C -- Field Name: field_type_c_user, Field type: Entity Reference
I'm building out a view displaying nodes that might reference any of the three of these content types, and the view needs to display information about the user referenced in the node's user field.
It seems inefficient to be using multiple different fields to be storing the exact same type of data. Is there an efficient way to go about creating a new field, field_user, and moving the data from all of these old fields into the new field? And then update all references throughout the site to use this new field?
Or would it be better to just add all three fields to my new view and call it a day?