Selecting all the rows based on distinct column value

Aug 8 2012 3:34 AM
Hi All ,

I have a Datatable say , having column column1,column2,column3.

ex data
column1 column2 column3
A           xyz        pqr
A           asd        poi
B           zxc        mnb
B           123        456
Now i want to export it to excel in the following way

column2  column3
A
xyz          pqr
asd          poi
B
zxc          mnb
123          456


Please tel me how to get the desired output as shown above .

Answers (1)