I have a shapefile that is a result of a merge between a land use chart (with two gaps) and two files to fill the gaps, but the atributes in the Land Use Chart are designated by "LEG" and in the Gap Charts are designated by "COS". In the merged chart, I got two columns that I would like to merge. They are both listed as "Text". I already tried the Field Calculator but the SQL code was invalid. Could anyone help me?
I am using ArcGIS 10.1 for Desktop.