This is what my Datagrid looks like
Name Phone Rank Years Participated View Details
All the columns are sortable. Now, I have people have have participated more that 1 year. So I want to group the entries by Name and then put all the years participated in a drop down menu. When a person selects a year it should then jump to the details page. Is it possible to put this functionality inside a Template Column somehow. Does anyone have any experience with this.