All,
I am trying to merge the two tables/data matrixes into a summary table thru the use of a pivot table but not having any luck.
I would appreciate any help.
Table 1
BP # BP Scope Leader Key
1.1 GR's - GC's Egbert 1.1-Egb
3.1 Garage Concrete Jones 3.1-Jon
3.2 Bldg Concrete Jones 3.2-Jon
4.1 Masonry Smith 4.1-Smi
4.2 Stone Smith 4.2-Smi
5.1 Structural Jones 5.1-Jon
5.2 Misc. & Stairs Jones 5.2-Jon
Table 2
Project XX Leader Egbert Jones Jones Smith
Any City BP# 1.1 3.1 3.2 4.1
Bldg. DIV Spec # Description Single/Multiple 1.1-Egb 3.1-Jon 3.2-Jon 4.1-Smi
G 03 03 10 00 Concrete Forming and Accessories Single X
G 03 03 20 00 Concrete Reinforcing Single X
O 03 03 30 00 Cast–In–Place Concrete Single X
G 03 03 30 00 Cast–In–Place Concrete Multiple X X
G 03 03 38 16 Post–Tensioned Concrete Single X
O 03 03 39 05 Concrete Sealers Not Assigned
G 03 03 39 05 Concrete Sealers Multiple X X
O 03 03 53 20 Cement Based Underlayment Not Assigned
G 04 04 05 13 Masonry Mortar and Grout Multiple X
Results
BP # BP Scope Leader
3.1 Garage Concrete Egbert
G 03 10 00 Concrete Forming and Accessories Single
G 03 20 00 Concrete Reinforcing Single
G 03 30 00 Cast–In–Place Concrete Single
G 03 38 16 Post–Tensioned Concrete Single
G 03 39 05 Concrete Sealers Multiple
Sorry I will try to figure out how to post a table
I am trying to merge the two tables/data matrixes into a summary table thru the use of a pivot table but not having any luck.
I would appreciate any help.
Table 1
BP # BP Scope Leader Key
1.1 GR's - GC's Egbert 1.1-Egb
3.1 Garage Concrete Jones 3.1-Jon
3.2 Bldg Concrete Jones 3.2-Jon
4.1 Masonry Smith 4.1-Smi
4.2 Stone Smith 4.2-Smi
5.1 Structural Jones 5.1-Jon
5.2 Misc. & Stairs Jones 5.2-Jon
Table 2
Project XX Leader Egbert Jones Jones Smith
Any City BP# 1.1 3.1 3.2 4.1
Bldg. DIV Spec # Description Single/Multiple 1.1-Egb 3.1-Jon 3.2-Jon 4.1-Smi
G 03 03 10 00 Concrete Forming and Accessories Single X
G 03 03 20 00 Concrete Reinforcing Single X
O 03 03 30 00 Cast–In–Place Concrete Single X
G 03 03 30 00 Cast–In–Place Concrete Multiple X X
G 03 03 38 16 Post–Tensioned Concrete Single X
O 03 03 39 05 Concrete Sealers Not Assigned
G 03 03 39 05 Concrete Sealers Multiple X X
O 03 03 53 20 Cement Based Underlayment Not Assigned
G 04 04 05 13 Masonry Mortar and Grout Multiple X
Results
BP # BP Scope Leader
3.1 Garage Concrete Egbert
G 03 10 00 Concrete Forming and Accessories Single
G 03 20 00 Concrete Reinforcing Single
G 03 30 00 Cast–In–Place Concrete Single
G 03 38 16 Post–Tensioned Concrete Single
G 03 39 05 Concrete Sealers Multiple
Sorry I will try to figure out how to post a table