unmerge datatable after merging in csharp

main.cs
// Assume that 'mergedTable' is the DataTable that was merged
// and contains merged rows and columns.

// Get the list of merged columns
var mergedColumns = mergedTable.Columns.Cast<DataColumn>()
    .Where(c => c.ExtendedProperties.ContainsKey("MergedColumn"))
    .ToList();

// Unmerge rows for each merged column
foreach (var column in mergedColumns)
{
    while (mergedTable.Rows.Cast<DataRow>().Any(r => r.IsNull(column)))
    {
        var groupedRows = mergedTable.Rows.Cast<DataRow>()
            .GroupBy(r => r[column])
            .Where(g => g.Count() > 1)
            .ToList();

        foreach (var group in groupedRows)
        {
            // Split the merged rows and insert them into the table
            var splitRows = group.ToList().Split();
            foreach (var splitRow in splitRows)
            {
                mergedTable.Rows.Add(splitRow);
            }
        }
    }

    // Remove the merged column
    mergedTable.Columns.Remove(column);
}
983 chars
33 lines