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