![Excel:如何合并表格(某些列不同)](https://linux22.com/image/1626937/Excel%EF%BC%9A%E5%A6%82%E4%BD%95%E5%90%88%E5%B9%B6%E8%A1%A8%E6%A0%BC%EF%BC%88%E6%9F%90%E4%BA%9B%E5%88%97%E4%B8%8D%E5%90%8C%EF%BC%89.png)
我在 Excel 中有一些以下格式的表格(十进制):
Table1 Table2 Table3 Table4
+------+------+------+ +------+------+------+------+ +------+------+------+ +------+------+------+------+
| A | B | C | | A | B | C | D | | A | C | B | | A | B | C | E |
+------+------+------+ +------+------+------+------+ +------+------+------+ +------+------+------+------+
| datA | datB | datC | | datA | datB | datC | datD | | datA | datC | datB | | datA | datB | datC | datE |
| datA | datB | datC | | datA | datB | datC | datD | | datA | datC | datB | | datA | datB | datC | datE |
| datA | datB | datC | | datA | datB | datC | datD | | datA | datC | datB | +------+------+------+------+
| datA | datB | datC | | datA | datB | datC | datD | | datA | datC | datB |
+------+------+------+ | datA | datB | datC | datD | +------+------+------+
| datA | datB | datC | datD |
+------+------+------+------+
并希望将它们合并到一张大表中。
+--------+------+------+------+------+------+
| Source | A | B | C | D | E |
+--------+------+------+------+------+------+
| Table1 | datA | datB | datC | | |
| Table1 | datA | datB | datC | | |
| Table1 | datA | datB | datC | | |
| Table1 | datA | datB | datC | | |
| Table2 | datA | datB | datC | datD | |
| Table2 | datA | datB | datC | datD | |
| Table2 | datA | datB | datC | datD | |
| Table2 | datA | datB | datC | datD | |
| Table2 | datA | datB | datC | datD | |
| Table2 | datA | datB | datC | datD | |
| Table3 | datA | datB | datC | | |
| Table3 | datA | datB | datC | | |
| Table3 | datA | datB | datC | | |
| Table3 | datA | datB | datC | | |
| Table4 | datA | datB | datC | | datE |
| Table4 | datA | datB | datC | | datE |
+--------+------+------+------+------+------+