How to merge datagridview columns?

Question

Hi I have a datagridview on windows form.Problem is there are some columns I need to merge in to another column.Tried to inllustrate what I want to do in this image. I have more than 40 columns in right side with some empty columns too.So all should merge with heading 1 column.Empty cells can be ignored.There are about 15 rows and how can I merge these values with c# code?

Nilesh Shah · Answer

you mean to say at runtime you want to decide which columns are to be merged? if not then I suggest to fetch result from DB in such a way that the column values are in the format you want to show on UI

RD Design · Answer

What I want actually run time merge cells.Any cell next to Value 9 should merge with it (As per above image)