This is my first post so please (kindly) let me know if I made an error in my question - and I apologize in advance if any are made.
I have 5 possible shifts (1-5) in this Shift column. For each Job Code in the 1st column I need to somehow merge each Job Code into 1 total 'qty' per each shift.
Here is a sample report of my 3 column table I am looking at:
<tbody>
</tbody>
Expected (hopeful) outcome below...
For instance the 'Loaded' Job Code would look like this:
<tbody>
</tbody>
I have 5 possible shifts (1-5) in this Shift column. For each Job Code in the 1st column I need to somehow merge each Job Code into 1 total 'qty' per each shift.
Here is a sample report of my 3 column table I am looking at:
| Job Code | qty | Shift |
| Received | 125 | 1 |
| Received | 53 | 1 |
| Received | 40 | 1 |
| Received | 87 | 1 |
| Received | 27 | 4 |
| Loaded | 43 | 4 |
| Loaded | 194 | 3 |
| Loaded | 53 | 1 |
| Loaded | 270 | 4 |
| Picked | 71 | 4 |
| Picked | 102 | 1 |
| Picked | 25 | 1 |
| Picked | 98 | 3 |
| Picked | 75 | 2 |
| Picked | 88 | 1 |
| Picked | 1 | 3 |
| Picked | 225 | 3 |
| Picked | 62 | 1 |
| Picked | 24 | 4 |
| Replenished | 9 | 4 |
| Replenished | 3 | 1 |
| Replenished | 5 | 1 |
| Replenished | 20 | 4 |
| Replenished | 28 | 1 |
| Cases Picked | 800 | 4 |
| Cases Picked | 875 | 2 |
| Cases Picked | 431 | 3 |
| Transfer | 42 | 1 |
| Transfer | 17 | 2 |
| Transfer | 104 | 3 |
| Transfer | 107 | 1 |
| Transfer | 11 | 4 |
| Putaway | 1 | 5 |
<tbody>
</tbody>
Expected (hopeful) outcome below...
For instance the 'Loaded' Job Code would look like this:
| Job Code | qty | Shift |
| Loaded | 53 | 1 |
| Loaded | 194 | 3 |
| Loaded | 313 | 4 |
<tbody>
</tbody>
