Help me! Pivot Table Failures...

[SteveT24]

Good day Mr. Excel community,

I'm hoping you can help me reorganize my data to suit my needs.

Here's what I have...

• A list of subcontractors (Column B) with the bid package they have been invited to (Column A). I've pasted a small portion of this list below, but it includes over 400 subcontractors for this single project. I've renamed the subcontractors for the purpose of seeking help on this forum.
  

02 110: Surveying	Subcontractor #1
02 110: Surveying	Subcontractor #2
02 110: Surveying	Subcontractor #3
02 110: Surveying	Subcontractor #4
02 110: Surveying	Subcontractor #5
02 110: Surveying	Subcontractor #6
02 110: Surveying	Subcontractor #7
02 130: Demolition	Subcontractor #8
02 130: Demolition	Subcontractor #9
02 130: Demolition	Subcontractor #1 0
02 130: Demolition	Subcontractor #1 1
02 130: Demolition	Subcontractor #1 2
02 150: Dewatering	Subcontractor #1 3
02 150: Dewatering	Subcontractor #1 4
02 150: Dewatering	Subcontractor #1 5
02 150: Dewatering	Subcontractor #1 6
02 170: Shoring	Subcontractor #1 7
02 170: Shoring	Subcontractor #1 8
02 170: Shoring	Subcontractor #1 9
02 170: Shoring	Subcontractor #2 0
02 170: Shoring	Subcontractor #2 1
02 170: Shoring	Subcontractor #2 2
02 170: Shoring	Subcontractor #2 3
02 170: Shoring	Subcontractor #2 4
02 170: Shoring	Subcontractor #2 5
02 170: Shoring	Subcontractor #2 6
02 170: Shoring	Subcontractor #2 7
02 180: SWPPP	Subcontractor #2 8
02 180: SWPPP	Subcontractor #2 9
02 180: SWPPP	Subcontractor #30
02 180: SWPPP	Subcontractor #31
02 180: SWPPP	Subcontractor #32
02 180: SWPPP	Subcontractor #33
02 200: Earthwork	Subcontractor #34
02 200: Earthwork	Subcontractor #35
02 200: Earthwork	Subcontractor #36
02 200: Earthwork	Subcontractor #37
02 200: Earthwork	Subcontractor #38
02 200: Earthwork	Subcontractor #39
02 200: Earthwork	Subcontractor #40
02 200: Earthwork	Subcontractor #41
02 200: Earthwork	Subcontractor #42
02 200: Earthwork	Subcontractor #43
02 200: Earthwork	Subcontractor #44

<tbody>
[TABLE="class: grid, width: 500"]
<colgroup><col style="mso-width-source:userset;mso-width-alt:8740;width:179pt" width="239"> <col style="mso-width-source:userset;mso-width-alt:12251;width:251pt" width="335"> </colgroup><tbody>[TR]
[TD="width: 239"]Bid Package
[/TD]
[TD="width: 335"]Company[/TD]

</tbody>

[/TR]
[TR]

[/TR]
[TR]

[/TR]
[TR]
[TD="class: xl65"]Here's what I need

• Each Bid Package to occupy 1 row, & the list of subcontractors invited to that bid package to fill out the row, 1 column each, as shown below.

[/TD]
[TD="class: xl65"][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 574"]
<tbody>[TR]
[TD="class: xl65, width: 239"]
[TABLE="class: grid, width: 500"]
<colgroup><col style="mso-width-source:userset;mso-width-alt:8740;width:179pt" width="239"> <col style="mso-width-source:userset;mso-width-alt:4205; width:86pt" width="115" span="7"> <col style="width:83pt" width="111" span="4"> </colgroup><tbody>[TR]
[TD="width: 239"]Bid Package
[/TD]
[TD="width: 115"]
[/TD]
[TD="width: 115"]
[/TD]
[TD="width: 115"]
[/TD]
[TD="width: 115"]
[/TD]
[TD="width: 115"]
[/TD]
[TD="width: 115"]
[/TD]
[TD="width: 115"]
[/TD]
[TD="width: 111"]
[/TD]
[TD="width: 111"]
[/TD]
[TD="width: 111"]
[/TD]
[TD="width: 111"]
[/TD]
[/TR]
[TR]
[TD]02 110: Surveying
[/TD]
[TD]Subcontractor #1
[/TD]
[TD]Subcontractor #2
[/TD]
[TD]Subcontractor #3[/TD]
[TD]Subcontractor #4[/TD]
[TD]Subcontractor #5 [/TD]
[TD]Subcontractor #6[/TD]
[TD]Subcontractor #7[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]02 130: Demolition
[/TD]
[TD]Subcontractor #8
[/TD]
[TD]Subcontractor #9[/TD]
[TD]Subcontractor #1 0[/TD]
[TD]Subcontractor #1 1[/TD]
[TD]Subcontractor #1 2[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]02 150: Dewatering
[/TD]
[TD]Subcontractor #1 3[/TD]
[TD]Subcontractor #1 4
[/TD]
[TD]Subcontractor #1 5
[/TD]
[TD]Subcontractor #1 6[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]02 170: Shoring
[/TD]
[TD]Subcontractor #1 7[/TD]
[TD]Subcontractor #1 8[/TD]
[TD]Subcontractor #1 9[/TD]
[TD]Subcontractor #2 0[/TD]
[TD]Subcontractor #2 1[/TD]
[TD]Subcontractor #2 2[/TD]
[TD]Subcontractor #2 3[/TD]
[TD]Subcontractor #2 4[/TD]
[TD]Subcontractor #2 5[/TD]
[TD]Subcontractor #2 6[/TD]
[TD]Subcontractor #2 7[/TD]
[/TR]
[TR]
[TD]02 180: SWPPP
[/TD]
[TD]Subcontractor #2 8[/TD]
[TD]Subcontractor #2 9[/TD]
[TD]Subcontractor #30[/TD]
[TD]Subcontractor #31[/TD]
[TD]Subcontractor #32[/TD]
[TD]Subcontractor #33
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]02 200: Earthwork
[/TD]
[TD]Subcontractor #34[/TD]
[TD]Subcontractor #35[/TD]
[TD]Subcontractor #36[/TD]
[TD]Subcontractor #37[/TD]
[TD]Subcontractor #38[/TD]
[TD]Subcontractor #39[/TD]
[TD]Subcontractor #40[/TD]
[TD]Subcontractor #41[/TD]
[TD]Subcontractor #42 [/TD]
[TD]Subcontractor #43[/TD]
[TD]Subcontractor #44 [/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="class: xl65, width: 335"][/TD]
[/TR]
</tbody>[/TABLE]


How can I accomplish this? Any help you can offer would be greatly appreciated.