I have 3 separate layers with the counties for 3 separate states: WA, OR, & ID. I want to combine them into one layer "Counties" so they all share an attribute table with the same fields. I am having issues with the Spatial Join and Union tools where instead of joining the fields, it creates new fields with the same names. The following image shows what I am describing.
How can I either have the layers merge and their attributes combine into one field. OR could I create a new field and populate it using the field calculator? I've tried my luck at writing an expression but my SQL and Python are very weak.