Hello,
i have duplicate values i.e part no in one column & i need to extract the stock qty of the part in next column but in only one cell with respective supplier as shown below.
kindly help.
Required -
Data Source -
i have duplicate values i.e part no in one column & i need to extract the stock qty of the part in next column but in only one cell with respective supplier as shown below.
kindly help.
Required -
Supplier | Part No | Stock As on Date |
AAA | ABC | 100 |
BBB | CBD | 200 |
CCC | XYZ | 100 |
DDD | XYZ | 700 |
EEE | CBD | 400 |
CCC | XYZ | 0 |
BBB | CBD | 0 |
Data Source -
Supplier | Part Source | Stock |
AAA | ABC | 100 |
BBB | CBD | 200 |
CCC | XYZ | 100 |
DDD | ABC | 300 |
EEE | CBD | 400 |
CCC | ABC | 600 |
DDD | XYZ | 700 |