show XML data horizontally

[blackpuppy]

I am working on reports using VSTO with Excel.

The program will produce the report data in XML and import into Excel. But
when I design the format and drag the data from XML Source, the data will be
shown vertically. And the report will be arranged in a cascade manner. I
wonder if there is a way to change this default behavior. That is, instead of
showing the data vertically, I want to show the data horizontally.

For example, a sales report about for various products in different areas
will be like this.

Area A
Product X Amount 1
Product Y Amount 2
Area B
Product X Amount 3
Product Y Amount 4
.....

I want to arrange the product horizontally, as shown below.

Product X Product Y
Area A Amount 1 Amount 2
Area B Amount 3 Amount 4

Does anyone have any idea?

Thanks!

 

[David McRitchie]

If you can produce your report with the area on the same row
so that each record has Area, Product, Amount
then you could use Pivot Tables http://www.contextures.com/tiptech.html

 

[blackpuppy]

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!