I have a salary table like:-<div><table border="0" cellspacing="2" cellpadding="2" width="500"><tbody><tr><td colspan="1"> EmpCode </td><td rowspan="1"> month</td><td rowspan="1"> salary</td></tr><tr><td> 1 </td><td> Feb2015</td><td> 32000</td></tr><tr><td> 1</td><td> march2015</td><td> 32000</td></tr></tbody><tbody><tr><td> 2</td><td> Feb2015 </td><td> 41000</td></tr></tbody><tbody><tr><td> 3</td><td> feb2015</td><td> 30000</td></tr></tbody><tbody><tr><td> 3</td><td> march2015</td><td> 30000</td></tr></tbody><tbody><tr><td> </td><td> </td><td> </td></tr></tbody></table></div><div> </div><div>i want result set like:-</div><div><table border="0" cellspacing="2" cellpadding="2" width="500" tagtype="InsertTable"><tbody><tr><td> EmpCode</td><td> Jan2015</td><td> Feb2015</td><td> March2015</td></tr><tr><td> 1</td><td> null </td><td> 32000</td><td> march2015</td></tr><tr><td> 2</td><td> null</td><td> 41000</td><td> null</td></tr></tbody><tbody><tr><td> 3</td><td> null</td><td> 30000</td><td> 30000</td></tr></tbody></table></div><div> </div><div> </div><div> </div>