I want to group by on one column in a C# datatable as below.

Question

Want to group by on one key column(RefPI) in a C# datatable.My table currently is: RefPI Date1 Date2 Status1 Status2 Status3 C2-EP1 d1 d2 C2-EP2 d3 d4 C2-EP3 d6 d7 C2-EP1 OK OK No C2-EP2 ok st1 DATA1 C2-EP2 Good yes yes //Expected result RefPI Date1 Date2 Status1 Status2 Status3 C2-EP1 d1 d2 OK OK No C2-EP2 d3 d4 ok st1 DATA1 Good yes yes C2-EP3 d6 d7 Above I wanted to group on C2-EP1,C2-EP2,C2-EP3.