in datagrid view the course should not be repeated

Question

i want to merge the particular row in data grid view.how can i do? output as follows in data grid view by using query in data grid view; Date Course 1 2 3 4 15/1/2013 REO GS Null VB Null 16/1/2013 REO Null RJ Null SK 17/1/2013 REO TM Null RJ GS 18/1/2013 REO VRV RJ Null Ms from the above output i want to show below as follows in data grid view; Date Course 1 2 3 4 15/1/2013 REO GS Null VB Null 16/1/2013 Null RJ Null SK 17/1/2013 TM Null RJ GS 18/1/2013 VRv RJ Null Ms from the above output i dont want to repeat the REO course for every date.the REO Course should be showed once in data grid view. how can i do. help me.