Hi

I am converting a dataset to xml and reading the xml file by dataset.readxml method and showing it in the grid and it appears as shown below. Now i wanted to read this in pivoted format like the second structure without using loops

F1      F2     F3     F4     F5
Group   1      2      3      4 
Design  5      6      7      8

F1      Value
Group   1   
Group   2   
Group   3   
Group   4
Design  5      
Design  6  
Design  7  
Design  8