Dataset to Excel reports

<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;&amp;amp;amp;lt;pre lang=&amp;amp;amp;quot;xml&amp;amp;amp;quot;&amp;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;amp;lt;/pre&amp;amp;amp;gt;&amp;amp;lt;/pre&amp;amp;gt;&amp;lt;/pre&amp;gt;&lt;/pre&gt;</pre>