Alright so tubular layout got me half way there. Each row in the data sheet has 3 vendors per item. My issue is with filtering.
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>
Item Number
Vendor 1
Vendor 2
Vendor 3
Sum of Sourcing
Sum of Manufacturing
Sum of IC/QA
Corn...