how to make row value as column header
<p>i got a problem with grid view ,because I'm new to asp.net(10 days),so i donno how to do it,so  can you guyz please help me out this problem..</p>

<p>i have a simple gridview ,and i have to make new grid with row value as column header name</p>

<p>Empname Earnngs Amount </p>

<p>Austin  HRA   20,000$</p>

<p>Austin  DA  1,000$</p>

<p>Austin  Basic   5,000$</p>

<p>and i have to make like this</p>

<p>.Austin  HRA   DA   BASIC</p>

<pre><code>    2000$ 2000$ 2000$
</code></pre>

<p>Please give some idea and some examples using C# to do it</p>
