Hi there,
I have 2 identical tables:
| n1 | n2 | n3 | n4 | n5 | |
| A | 2 | ||||
| B | |||||
| C | |||||
| D | |||||
| E | |||||
| F | |||||
| G | 8 | ||||
| H | |||||
| I | 9 |
| n1 | n2 | n3 | n4 | n5 | |
| A | 5 | ||||
| B | |||||
| C | |||||
| D | |||||
| E | |||||
| F | |||||
| G | 9 | 7 | |||
| H | |||||
| I | 1 |
I need to combine them into one table, and the numbers should be combined as well:
| n1 | n2 | n3 | n4 | n5 | |
| A | 2 | 5 | |||
| B | |||||
| C | |||||
| D | |||||
| E | |||||
| F | |||||
| G | 9 | 15 | |||
| H | |||||
| I | 10 |
Is there any easy way to achieve this?
Thank you,
Solved! Go to Solution.
Hi @ultrarunner I mocked up a workflow let me know what you think?
Hi @JosephSerpis,
Thank you so much! I was not sure how to combine the tables. Union tool should do it.
Regards,
