how to linq pivot use reflection genric

// Define a class to represent the rows of the pivoted data
public class PivotedData
{
    public string YearMonth { get; set; }
    public int JNum1 { get; set; }
    public int JNum2 { get; set; }
    // Add more properties for each value column
}

// Get the data from your DAL
var data = dal.GetData();

// Use reflection to get the list of value column names
var valueColumns = data.Columns.Cast()
    .Where(c => c.ColumnName.StartsWith("JNum"))
    .Select(c => c.ColumnName)
    .ToList();

// Use LINQ to group the data by YearMonth
var groupedData = data.AsEnumerable()
    .GroupBy(row => row.Field("YearMonth"))
    .Select(group =>
    {
        // Create a new PivotedData object for each group
        var pivotedRow = new PivotedData { YearMonth = group.Key };

        // Use reflection to set the value of each property on the pivoted row
        foreach (var valueColumn in valueColumns)
        {
            var property = typeof(PivotedData).GetProperty(valueColumn);
            var sum = group.Sum(row => row.Field(valueColumn));
            property.SetValue(pivotedRow, sum);
        }

        return pivotedRow;
    })
    .ToList();