nparsons75
Well-known Member
- Joined
- Sep 23, 2013
- Messages
- 1,256
- Office Version
- 2016
Hi,
I have a table of contents that I need to create a pivot table for. The issue is that for each row of data in the table i need to record a quantity against multiple part types. Please see example table below.
<tbody>
</tbody>
So, from a pivot table I need to be able to find the overall total quantity per each part type. The result of the pivot table will be hopefully like this.
<tbody>
</tbody>
Really hope this is possible, thanks in advance for any help.
I have a table of contents that I need to create a pivot table for. The issue is that for each row of data in the table i need to record a quantity against multiple part types. Please see example table below.
PART | QTY | PART | QTY | PART | QTY | PART | QTY | PART | QTY |
001 | 10 | 002 | 12 | 003 | 1 | ||||
004 | 9 | 005 | 6 | 002 | 4 | 001 | 2 |
<tbody>
</tbody>
So, from a pivot table I need to be able to find the overall total quantity per each part type. The result of the pivot table will be hopefully like this.
PART | QTY |
001 | 12 |
002 | 16 |
003 | 1 |
004 | 9 |
005 | 6 |
006 | 0 |
007 | 0 |
<tbody>
</tbody>
Really hope this is possible, thanks in advance for any help.