# Merge Tables/Matrix with Pivot table

#### Mjk7239

##### New Member
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

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

### Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},\$Z\$1:\$Z\$99,\$Y\$1:\$Y\$99),2,False) to lookup Y values to left of Z values.

Replies
0
Views
478
Replies
11
Views
887
Replies
6
Views
798
Replies
0
Views
327
Replies
0
Views
242

1,195,673
Messages
6,011,087
Members
441,582
Latest member
Topkapi

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back