diamond diamond

diamond diamond

  • NA
  • 133
  • 32.8k

selecting row of datatable by duplicated value of one column

Feb 2 2014 3:07 AM
Hi

I have a datatable which has 3 column. for one value of first column has many different value and some of them duplicated value in the second column. I want split the rows that are same value in second column.


first            second           third

1                 5                    d
1                 5                     w
1                 8                     q
1                 5                    y
1                 8                    h
2                  4                   p
1                 5                    l
2                  4                   e


I want category be as same below:
view1:
1         5       d
1         5       w
1         5       y
1         5       l


view2:
1   8   h
1   8   q


view3:
2  4   e
2  4   p


Please help me
I need urgently


Answers (4)