# Pivot table help

#### MRomanow

##### New Member
I have a pivot table with Plant, Supplier and Dock Code. The row is the plant and shows all the suppliers with all their total weights. The plant doesn't extend down though so I cannot do a VLOOKUP off of the data by the plants

Data
PLANT SUPPLIER DOCKCDE Sum of DAILY WEIGHT
Plant A Supplier 1 Dock 1 100
Supplier 2 Dock 2 200
Supplier 3 Dock 1 300
Plant B Supplier 4 Dock 1 250
Supplier 1 Dock 2 350

Is there any easy formula to add to the left of the Pivot Table to extend the PLANT down to fill in all the blanks for Plant A, Plant B, etc???

### Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

#### Norie

##### Well-known Member
As far as I'm aware you can't fill in the blanks in a pivot table.

Instead of using VLOOKUP you should use GETPIVOTDATA to get data from pivot tables.

#### MRomanow

##### New Member
This doesn;t work when I need to concatenate 3 separete field headings such as Plant, Supplier and Dock Code to Vlookup off off. I know there is a formula that you can enter to the left of the Pivot Table that looks at the first row header, such as plant, and shows the plant. The next cell below it would look at the row heading and see nothing, since the Plant was already used the first time, and give you a blank but this formula would look for the last filled in plant. I cannot seem to remember this formula though.

#### Norie

##### Well-known Member
Could it be GETPIVOTDATA?

That function is intended to extract data from pivot tables.

Can you post the raw data?

Replies
6
Views
316
Replies
2
Views
294
Replies
2
Views
367
Replies
0
Views
83
Replies
1
Views
1K

1,195,640
Messages
6,010,880
Members
441,571
Latest member
stolenweasel

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