I have to combine 2 tables & create a consolidated table to reflect data from both tables. If the names are same, it should add the qty. Otherwise, it should add a new row. Final combined table should be sorted by the name.
I tried using power query merge, but not getting the correct results. Can the experts suggest how this can be done please?
For example consider the following tables.
The final combined table should be like this -
I tried using power query merge, but not getting the correct results. Can the experts suggest how this can be done please?
For example consider the following tables.
excel problems.xlsx | ||||
---|---|---|---|---|
C | D | |||
2 | Name | Qty | ||
3 | bcd | 2 | ||
4 | de | 19 | ||
5 | fghi | 954 | ||
Sheet9 |
excel problems.xlsx | ||||
---|---|---|---|---|
B | C | |||
2 | Name | Qty | ||
3 | abc | 56 | ||
4 | xyz | 37 | ||
5 | fghi | 6 | ||
6 | bcd | 10 | ||
7 | mnop | 88 | ||
Sheet10 |
The final combined table should be like this -
excel problems.xlsx | ||||
---|---|---|---|---|
B | C | |||
2 | Name | Qty | ||
3 | abc | 56 | ||
4 | bcd | 12 | ||
5 | de | 19 | ||
6 | fghi | 960 | ||
7 | mnop | 88 | ||
8 | xyz | 37 | ||
Sheet11 |