Hi,
1st sheet of my excel:
<tbody>
</tbody>
2nd sheet of my excel:
<tbody>
</tbody>
Required Output:
<tbody>
</tbody>
Is it possible to automate this?
Please help with the formula.
Thank you in advance.
Regards,
Prasanna.A
1st sheet of my excel:
35582ac | 35582de | 38920aa | 38032f | |
332 | ||||
122 | ||||
21 | ||||
32 |
<tbody>
</tbody>
2nd sheet of my excel:
IR No | Assembly No | Qty |
04 | 35582ac | 2 |
122 | 38920aa | 3 |
122 | 38852de | 1 |
32 | 38032f | 2 |
332 | 35582ac | 2 |
332 | 38852de | 3 |
<tbody>
</tbody>
Required Output:
35582ac | 35582de | 38920aa | 38032f | |
332 | 2 | 3 | 0 | 0 |
122 | 0 | 1 | 3 | 0 |
21 | 0 | 0 | 0 | 0 |
32 | 0 | 0 | 0 | 2 |
<tbody>
</tbody>
Is it possible to automate this?
Please help with the formula.
Thank you in advance.
Regards,
Prasanna.A