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!
--
The more you know, the less you know.