I am calling upon the users of this forum to submit their creative solutions to a problem I have.
I need to take data from ColumnA in ShapefileA, and merge it with empty ColumnB in ShapefileB.
ShapefileA ShapefileB End Result
I tried using the "Append (Data Management)" tool for this job, and it kind of did what I needed. ShapefileB gained the data from ColumnA, like I wanted, but the Append tool created a duplicate feature with those new values, instead of using the feature that was already in place. End result: I got the feature that I wanted, but the original feature I wanted to use was left behind and now needs to be hunted down and removed.
What process would you use in order to get to the desired end result?