JumboCactuar
Well-known Member
- Joined
- Nov 16, 2016
- Messages
- 785
- Office Version
- 365
- Platform
- Windows
Hi,
i have the following data
<tbody>
</tbody>
I need to do the following:
If Reserve QTY fits into Priority Location then output them like this:
<tbody>
</tbody>
Not even sure how to go about doing this, i thought probably using pivots but its tricky
Appreciate any help
i have the following data
ITEM NO | TYPE | LOCATION | QTY | MAX QTY |
11224 | PRIORITY | AL4401 | 4 | 14 |
11224 | RESERVE | GL1202 | 12 | 14 |
55322 | PRIORITY | AL5503 | 8 | 23 |
55322 | RESERVE | GL1104 | 10 | 23 |
55322 | RESERVE | GL1105 | 2 | 23 |
43112 | PRIORITY | AL5512 | 6 | 100 |
43112 | RESERVE | GL4401 | 55 | 100 |
67442 | PRIORITY | AL5212 | 14 | 15 |
67442 | RESERVE | GL1201 | 5 | 15 |
57743 | PRIORITY | AL5603 | 0 | 5 |
57743 | RESERVE | HL1201 | 4 | 5 |
80888 | PRIORITY | BL0102 | 5 | 9 |
80888 | RESERVE | GL1203 | 1 | 1 |
80888 | RESERVE | HL1204 | 1 | 1 |
80888 | RESERVE | GL5503 | 1 | 1 |
<tbody>
</tbody>
I need to do the following:
If Reserve QTY fits into Priority Location then output them like this:
ITEM NO | FROM | TO | QTY |
11224 | GL1202 | AL4401 | 10 |
55322 | GL1104 | AL5503 | 10 |
55322 | GL1105 | AL5503 | 2 |
43112 | GL4401 | AL5512 | 55 |
57743 | HL1201 | AL5603 | 4 |
80888 | GL1203 | BL0102 | 1 |
80888 | HL1204 | BL0102 | 1 |
80888 | GL5503 | BL0102 | 1 |
<tbody>
</tbody>
Not even sure how to go about doing this, i thought probably using pivots but its tricky
Appreciate any help