<pre lang="xml"><pre lang="xml">&lt;pre lang=&quot;xml&quot;&gt;&amp;lt;pre lang=&amp;quot;xml&amp;quot;&amp;gt;&amp;amp;lt;pre lang=&amp;amp;quot;xml&amp;amp;quot;&amp;amp;gt;I need dataset data to be exported to excel. The show stopper is : i need to transpose the data present in the dataset while presenting it in the excel.eg: RollNo Name Age Phone number 101 ABC 18 9821982121 102 PQR 17 103 XYZ 20 9819981919 104 LMN 18 9898989898 105 STU 105 STU 19 And the result should be like this. RollNo | 102 | 103 | 104 | 105 | 105 Name | PQR | XYZ | LMN | STU | STU Age | 17 | 20 | 18 | | 19 Phone number | | 9819981919 | 9898989898 | | The values will be dynamic, and the number of data present may be not equal in every records. Also, there may be multiple entries of the same record(Roll number 101 repeated twice) with variable data present( )&amp;amp;lt;/pre&amp;amp;gt;&amp;lt;/pre&amp;gt;&lt;/pre&gt;</pre></pre>
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)