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