in data grid view how to merge the particular row

See more:

C#

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.