Hello,
I have a report that generates based on InfoPath forms filled out and downloaded from SharePoint. In this report, there are 3 columns each for part numbers and part descriptions (Part 1 #, Part 1 Description, Part 2 #, Part 2 Description, Part 3 #, Part 3 Description). In the report for the necessary department, these parts are listed in the pivot table under the merchandise they go with. I'm trying to figure out a way to combine the information from these columns to be able to list all of the requested parts based on a particular merchandise. If it's something that can be done in the tools for the pivot table, great, if it takes a formula on the data tab, that works too. I've tried searching all over and cannot find a solution that helps with this.
I'm trying to go from data pulls presenting like this:
<tbody>
</tbody>
To a pivot table reflecting like this:
<tbody>
</tbody>
I have a report that generates based on InfoPath forms filled out and downloaded from SharePoint. In this report, there are 3 columns each for part numbers and part descriptions (Part 1 #, Part 1 Description, Part 2 #, Part 2 Description, Part 3 #, Part 3 Description). In the report for the necessary department, these parts are listed in the pivot table under the merchandise they go with. I'm trying to figure out a way to combine the information from these columns to be able to list all of the requested parts based on a particular merchandise. If it's something that can be done in the tools for the pivot table, great, if it takes a formula on the data tab, that works too. I've tried searching all over and cannot find a solution that helps with this.
I'm trying to go from data pulls presenting like this:
Set Name | Part # 1 | Part 1 Desc | Part # 2 | Part 2 Desc | Part # 3 | Part Desc 3 |
Set 1 | 1234567 | Widget | 1234568 | Doodad | 7654321 | Thingamajig |
Set 1 | 1234568 | Doodad | 1234567 | Widget |
<tbody>
</tbody>
To a pivot table reflecting like this:
Set Name | Part Number | Part Description | Total Needed |
Set 1 | 1234567 | Widget | 2 |
1234568 | Doodad | 2 | |
7654321 | Thingamajig | 1 |
<tbody>
</tbody>