Code,Name to be displayed only once

Hello Ramco,

Please use this once,

var data = new List
						{
							new { Code = "C01", Name = "ABC", Debit = 500, Credit = (int?)null },
							new { Code = "C01", Name = "ABC", Debit = (int?)null, Credit = 200 },
							new { Code = "C01", Name = "ABC", Debit = 200, Credit = (int?)null },
							new { Code = "C01", Name = "ABC", Debit = 200, Credit = (int?)null },
						};

			var processedData = data
				.Select((row, index) => new
				{
					Code = index == 0 || (row.Code != data[index - 1].Code) ? row.Code : string.Empty,
					Name = index == 0 || (row.Name != data[index - 1].Name) ? row.Name : string.Empty,
					row.Debit,
					row.Credit
				})
				.ToList();

			Console.WriteLine($"Code \tName \tDebit\tCredit");
			foreach (var row in processedData)
			{
				Console.WriteLine($"{row.Code}\t{row.Name}\t{row.Debit}\t{row.Credit}");
			}

This will give you resulst as below,

Code    Name    Debit   Credit
C01     ABC     500
                                      200
                        200
                        200

To display Code and Name only once for each group of data (based on Code and Name), you can group the data by Code and Name and suppress repeated values in their columns. This is commonly done in reporting or rendering grouped data in a grid-like format.

Here’s how you can achieve this in C# using LINQ and Blazor:

Data Example

public class Transaction
{
    public string Code { get; set; }
    public string Name { get; set; }
    public decimal? Debit { get; set; }
    public decimal? Credit { get; set; }
}

Data Preparation

var transactions = new List
{
    new Transaction { Code = "C01", Name = "ABC", Debit = 500, Credit = null },
    new Transaction { Code = "C01", Name = "ABC", Debit = null, Credit = 200 },
    new Transaction { Code = "C01", Name = "ABC", Debit = 200, Credit = null },
    new Transaction { Code = "C01", Name = "ABC", Debit = 200, Credit = null },
};

Group and Suppress Repeats

var groupedTransactions = transactions
    .Select((t, index) => new
    {
        Code = index == 0 || transactions[index - 1].Code != t.Code ? t.Code : null,
        Name = index == 0 || transactions[index - 1].Name != t.Name ? t.Name : null,
        t.Debit,
        t.Credit
    }).ToList();

Render in Blazor

Here’s an example of how to render the grouped data in a Blazor component:

        @foreach (var item in groupedTransactions)
        {
            
        }
    

    

        

            
Code
            
Name
            
Debit
            
Credit
        
    
    

                
@item.Code
                
@item.Name
                
@item.Debit
                
@item.Credit
            

Output Table

Code	Name	Debit	Credit
C01	ABC	500
			200
		200
		200

This approach groups the data and suppresses repeated values for Code and Name, while preserving the full detail of the transactions. Let me know if you need additional clarifications!