tommiexboi
New Member
- Joined
- Apr 24, 2017
- Messages
- 24
- Office Version
- 365
- Platform
- Windows
Hello,
Basically, I have over 1200 part numbers and I'm looking at an 8 quarter forecast.
I am trying to get the below result that will be quick and efficient. Would like to be able to sort by quarter and etc.
Any help will be greatly appreciated.
Current:
<tbody>
</tbody>
Result Needed:
<tbody>
</tbody>
Basically, I have over 1200 part numbers and I'm looking at an 8 quarter forecast.
I am trying to get the below result that will be quick and efficient. Would like to be able to sort by quarter and etc.
Any help will be greatly appreciated.
Current:
Part Number | QTR 1 | QTR 2 | QTR 3 | QTR 4 | QTR 1 | QTR 2 | QTR 3 | QTR 4 |
ABC123 | 67 | 8 | 8 | 3 | 1 | 3 | 0 | 4 |
ABC124 | 1 | 2 | 10 | 4 | 2 | 6 | 0 | 6 |
ABC125 | 3 | 5 | 12 | 5 | 3 | 9 | 3 | 3 |
<tbody>
</tbody>
Result Needed:
Part Number | Quarter | Quantity |
ABC123 | QTR 1 | 67 |
ABC123 | QTR 2 | 8 |
ABC123 | QTR 3 | 8 |
ABC123 | QTR 4 | 3 |
ABC123 | QTR 1 | 1 |
ABC123 | QTR 2 | 3 |
ABC123 | QTR 3 | 0 |
ABC123 | QTR 4 | 4 |
ABC124 | QTR 1 | 1 |
ABC124 | QTR 2 | 2 |
ABC124 | QTR 3 | 10 |
ABC124 | QTR 4 | 4 |
ABC124 | QTR 1 | 2 |
ABC124 | QTR 2 | 6 |
ABC124 | QTR 3 | 0 |
ABC124 | QTR 4 | 6 |
ABC124 | QTR 1 | 3 |
ABC124 | QTR 2 | 5 |
ABC124 | QTR 3 | 12 |
ABC124 | QTR 4 | 5 |
ABC124 | QTR 1 | 3 |
ABC124 | QTR 2 | 9 |
ABC124 | QTR 3 | 3 |
ABC124 | QTR 4 | 3 |
<tbody>
</tbody>