What I want is each area per row. In each row, the 1st column is the area
name, the 2nd column is the sales amount for product X, the 3rd column is the
sales amount for product Y, and maybe the 4th column for product Z, etc.

Any instructive guide on how to do this? I am not familiar with the
formatting in Excel, such as using Pivot.

Thanks!
--
The more you know, the less you know.