Can one devise a pivot table based upon two sheets (for two different
companies) with similar following columns:
Branch Product Amount Qty

as follows, instead of simply Rows & Columns?
<PIVOT TABLE
Amount Qty
Branch-A Product-1
Product-2
Product-3

All Modes & Codes shall be highly obliged.

Thanx & regards