How to merge datagridview columns?

May 31 2017 7:18 AM

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?