Pivot Table Help

[Rashid]

I have two sperate sheets of data in a Workbook. The data is as follows:

Sheet 1 data
Location SKU Description P.O. PRICE2 Invoice Price Variance


Sheet 2 data
Location SKU Description Standard Cost P.O Price1 Variance


How can I create a pivot table with the following layout

ROW COLUMN
Location P.O. PRICE2
Sku Invoice Price
Description Variance
Standard Cost
P.O Price1
Variance

Thanks,

Rashid

[steven1001]

You could try the following..

In the first sheet add some extra column headings that are the same as the headings from the second sheet that are not already in the first sheet.

In the second sheet insert some blank columns so everything lines up with the column headings in the first sheet.

Copy/paste the data from the second sheet as additional rows on the first sheet.

Create the pivot table in the normal way dragging the required data fields into the data area. Create calculated fields to show the required variances

regards..