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,