Hi asitmisra,

Please refer below article.

Merge GridView Cells or Columns in a Row in ASP.Net using C# VB.Net

Hi asitmisra,

Please share your complete code with HTML and provide your table Records so that we can help you out to achieve your task.

Emp ID	EmpName	Designation	Date Of Joining	Salary	Department	 	 
PO11	Vishal Gaur	Director	11 Jan 1996	250000	IT	Delete	Edit
PO13	Arvind	Developer	28 Feb 1998	50000	support	Delete	Edit
PO14	Ravi	Developer	24 Mar 1998	5000	it	Delete	Edit
PO15	Abhishek	QA	23 Apr 2016	10000	quality	Delete	Edit
PO16	Asit	Developer	02 Mar 2016	10000	IT	Delete	Edit
PO17	Raunak	Developer	02 Feb 2016	35000	IT	Delete	Edit
PO18	Megha	QA	11 Dec 2014	42000	Quality	Delete	Edit
PO19	heena	developer	02 Dec 2014	65000	IT	Delete	Edit

html

<asp:GridView ID="Empdata" runat="server" AutoGenerateColumns="false" Font-Names="Arial"
    Font-Size="11px" HeaderStyle-BackColor="DarkOliveGreen" ShowFooter="true" AllowPaging="True"
    OnPageIndexChanging="OnPaging" OnRowCancelingEdit="CancelEdit" OnRowEditing="EditRecord"
    OnRowUpdating="UpdateRecord" PageSize="20" HeaderStyle-HorizontalAlign="Center"
    HorizontalAlign="Center" OnRowDataBound="OnRowDataBound">
    <Columns>
        <asp:TemplateField ItemStyle-Width="35px" HeaderText="Emp ID">
            <ItemTemplate>
                <asp:Label ID="lbEmpID" runat="server" Text='<%# Eval("EmpID")%>'></asp:Label>
            </ItemTemplate>
            <EditItemTemplate>
                <asp:TextBox ID="txtEmpID" runat="server" Text='<%# Eval("EmpID")%>'></asp:TextBox>
            </EditItemTemplate>
            <FooterTemplate>
                <asp:TextBox ID="txtEmpID" Width="35px" runat="server"></asp:TextBox>
            </FooterTemplate>
        </asp:TemplateField>
        <asp:TemplateField ItemStyle-Width="35px" HeaderText="EmpName">
            <ItemTemplate>
                <asp:Label ID="lbEmpName" runat="server" Text='<%# Eval("EmpName")%>'></asp:Label>
            </ItemTemplate>
            <EditItemTemplate>
                <asp:TextBox ID="txtEmpName" runat="server" Text='<%# Eval("EmpName")%>'></asp:TextBox>
            </EditItemTemplate>
            <FooterTemplate>
                <asp:TextBox ID="txtEmpName" Width="35px" runat="server"></asp:TextBox>
            </FooterTemplate>
        </asp:TemplateField>
        <asp:TemplateField ItemStyle-Width="25px" HeaderText="Designation">
            <ItemTemplate>
                <asp:Label ID="lblDesignation" runat="server" Text='<%# Eval("Designation")%>'></asp:Label>
            </ItemTemplate>
            <EditItemTemplate>
                <asp:TextBox ID="txtDesignation" runat="server" Text='<%# Eval("Designation")%>'></asp:TextBox>
            </EditItemTemplate>
            <FooterTemplate>
                <asp:TextBox ID="txtDesignation" runat="server"></asp:TextBox>
            </FooterTemplate>
        </asp:TemplateField>
        <asp:TemplateField ItemStyle-Width="25px" HeaderText="Date Of Joining">
            <ItemTemplate>
                <asp:Label ID="lblDateOfJoining" runat="server" Text='<%# Eval("DateOfJoining","{0:dd MMM yyyy}")%>'></asp:Label>
            </ItemTemplate>
            <EditItemTemplate>
                <asp:TextBox ID="txtDateOfJoining" runat="server" Text='<%# Eval("DateOfJoining","{0:dd MMM yyyy}")%>'></asp:TextBox>
            </EditItemTemplate>
            <FooterTemplate>
                <asp:TextBox ID="txtDateOfJoining" runat="server"></asp:TextBox>
            </FooterTemplate>
        </asp:TemplateField>
        <asp:TemplateField ItemStyle-Width="25px" HeaderText="Salary">
            <ItemTemplate>
                <asp:Label ID="lblSalary" runat="server" Text='<%# Eval("Salary")%>'></asp:Label>
            </ItemTemplate>
            <EditItemTemplate>
                <asp:TextBox ID="txtSalary" runat="server" Text='<%# Eval("Salary")%>'></asp:TextBox>
            </EditItemTemplate>
            <FooterTemplate>
                <asp:TextBox ID="txtSalary" runat="server"></asp:TextBox>
            </FooterTemplate>
        </asp:TemplateField>
        <asp:TemplateField ItemStyle-Width="25px" HeaderText="Department">
            <ItemTemplate>
                <asp:Label ID="lblDepartment" runat="server" Text='<%# Eval("Department")%>'></asp:Label>
            </ItemTemplate>
            <EditItemTemplate>
                <asp:TextBox ID="txtDepartment" runat="server" Text='<%# Eval("Department")%>'></asp:TextBox>
            </EditItemTemplate>
            <FooterTemplate>
                <asp:TextBox ID="txtDepartment" runat="server"></asp:TextBox>
            </FooterTemplate>
        </asp:TemplateField>
        <asp:TemplateField>
            <ItemTemplate>
                <asp:LinkButton ID="lnkRemove" runat="server" CommandArgument='<%# Eval("EmpID")%>'
                    OnClientClick="return confirm('Do you want to delete?')" Text="Delete" OnClick="DeleteRecord"></asp:LinkButton>
            </ItemTemplate>
            <FooterTemplate>
                <asp:Button ID="btnAdd" runat="server" Text="Add" OnClick="AddNewRecord" />
            </FooterTemplate>
        </asp:TemplateField>
        <asp:CommandField ShowEditButton="True" />
    </Columns>
</asp:GridView>

 Protected Sub OnDataBound(sender As Object, e As EventArgs)
        For i As Integer = Empdata.Rows.Count - 1 To 1 Step -1
            Dim row As GridViewRow = Empdata.Rows(i)
            Dim previousRow As GridViewRow = Empdata.Rows(i - 1)
            For j As Integer = 0 To row.Cells.Count - 2
                'run this loop for the column which you thing the data will be similar
                If DirectCast(row.Cells(j).FindControl("lblDesignation"), Label).Text = DirectCast(previousRow.Cells(j).FindControl("lblDesignation"), Label).Text Then
                    If previousRow.Cells(2).RowSpan = 0 Then
                        If row.Cells(2).RowSpan = 0 Then
                            previousRow.Cells(2).RowSpan += 2
                        Else
                            previousRow.Cells(2).RowSpan = row.Cells(2).RowSpan + 1
                        End If
                        row.Cells(2).Visible = False
                    End If
                End If
                'run this loop for the column which you thing the data will be similar
                If DirectCast(row.Cells(j).FindControl("lblDepartment"), Label).Text = DirectCast(previousRow.Cells(j).FindControl("lblDepartment"), Label).Text Then
                    If previousRow.Cells(5).RowSpan = 0 Then
                        If row.Cells(5).RowSpan = 0 Then
                            previousRow.Cells(5).RowSpan += 2
                        Else
                            previousRow.Cells(5).RowSpan = row.Cells(5).RowSpan + 1
                        End If
                        row.Cells(5).Visible = False
                    End If
                End If
            Next
        Next
    End Sub