A1 | B1 | C1 | D1 |
Order No: | BOX or WRAP | Medium | Large |
MK23 | 1 | 1 | 0 |
MK23 | 1 | 0 | 1 |
MK23 | 1 | 1 | 0 |
MK24 | 1 | 1 | 0 |
MK24 | 1 | 0 | 1 |
<tbody>
</tbody>
B1, have sorted to 1 for BOX and 0 for Wrap
I would like to count, how many medium and how many large boxes for each Order No:
The output should be as below:
Order No: | Medium Box | Large Box |
MK23 | 2 | 1 |
MK24 | 1 | 1 |
<tbody>
</tbody>
Thanks in advance