See:

    http://www.topxml.com/code/default.asp?p=3&id=v20010226151246


Cheers,
Dimitre Novatchev


"Lee" <lee.jenkins.ca@g...> wrote in message 
news:1180653377.445712.231260@p......
>I have a xml file, here is sample part:
> <?xml version="1.0" encoding="UTF-8"?>
> <ProducsList>
> <Product id="1">
> <SpecList>
> <Spec>
> <SpecLabel>Height</SpecLabel>
>  <SpecValue>10</SpecValue>
>  <SpecCat>Dimension</SpecCat>
>  </Spec>
> <Spec>
> <SpecLabel>Width</SpecLabel>
>  <SpecValue>6</SpecValue>
>  <SpecCat>Dimension</SpecCat>
>  </Spec>
>  <Spec>
> <SpecLabel>Weight</SpecLabel>
>  <SpecValue>20.5</SpecValue>
>  <SpecCat>Weigth</SpecCat>
>  </Spec>
> </SpecList>
> </Prodcut>
> <Product id="2">
> <SpecList>
> <Spec>
> <SpecLabel>Height</SpecLabel>
>  <SpecValue>8</SpecValue>
>  <SpecCat>Dimension</SpecCat>
>  </Spec>
> <Spec>
> <SpecLabel>Width</SpecLabel>
>  <SpecValue>5</SpecValue>
>  <SpecCat>Dimension</SpecCat>
>  </Spec>
>  <Spec>
> <SpecLabel>Weight</SpecLabel>
>  <SpecValue>18</SpecValue>
>  <SpecCat>Weigth</SpecCat>
>  </Spec>
> </SpecList>
> </Prodcut>
> <Product id="3">
> <SpecList>
> <Spec>
> <SpecLabel>Height</SpecLabel>
>  <SpecValue>5</SpecValue>
>  <SpecCat>Dimension</SpecCat>
>  </Spec>
> <Spec>
> <SpecLabel>Width</SpecLabel>
>  <SpecValue>2</SpecValue>
>  <SpecCat>Dimension</SpecCat>
>  </Spec>
>  <Spec>
> <SpecLabel>Weight</SpecLabel>
>  <SpecValue>10</SpecValue>
>  <SpecCat>Weigth</SpecCat>
>  </Spec>
> </SpecList>
> </Prodcut>
> </ProductsList>
>
> I need to create a table look like that based on that xml file:
>
> ----------------------------------------------------
> Label Product 1 product 2 product 3
> ----------------------------------------------------
> Height 10 8 5
> Width 6 5 2
> Weight 20.5 18 10
>
> I am totally losed, I don't know how to create that table. any one has
> any idea about that? thank you very much.
>
> Also how many Spec in SpecList is unkown.
>
> Thanks for the help.
>