Open the Table To Table tool. For Input Rows, select School1 and type an Output Name. Next, expand Fields. The drop-down menu is also available from the Export Table option.
In the Fields drop-down menu, select the duplicate fields to delete. Click the field and click the red X next to the field name. This workaround can only be used if the duplicate fields contain the same values. In this example, in the School1 table, the different Teacher_Last_Name cells contain different data, so by removing that specific field, the unique data is lost. To remove fields with duplicate names, ensure that both fields contain the exact same data.