我有一个csv文件，其中有多个列的数据

Name, Description, Date
"ABC", "Hello testing", "2022-09-14"
"ABC", "Hello testing123", "2022-09-15"
"ABC", "Hello testing245", "2022-09-16"
"ABC1", "Hello testing", "2022-09-14"
"ABC1", "Hello testing143", "2022-09-16"
"ABC2", "Hello testing2", "2022-09-14"
"ABC2", "Hello testing2", "2022-09-15"

我想改变名称值成列，并相应地添加行数据

当前输出：

ABC                ,ABC1              ,ABC2
"Hello testing"    , "Hello testing"  , "Hello testing" 
"Hello testing123", "Hello testing123","Hello testing123"
"Hello testing245", "Hello testing245","Hello testing245"
"Hello testing"   ,  "Hello testing"  , "Hello testing"
"Hello testing143",  "Hello testing143",  "Hello testing143"
"Hello testing2"  ,  "Hello testing2"  ,"Hello testing2" 
"Hello testing2"  ,  "Hello testing2"  ,  "Hello testing2"

我需要添加列名值作为标题，然后根据示例输出添加描述和日期

示例输出：

Date ,ABC               ,ABC1           ,ABC2
14,   Hello testing,    Hello testing   ,Hello testing2
15,   Hello testing123,                 ,Hello testing2
16,   Hello testing245, Hello testing143

我已经读取了csv，然后我的输出表在所有列的所有行中显示相同的数据。我如何根据名称对其进行分组？

代码：

using (var reader = new StreamReader("data.csv"))

        using (var csv = new CsvReader(reader, CultureInfo.InvariantCulture))
        {
           
            // Extract the column headers from the first row
            csv.Read();
            csv.ReadHeader();
            int columnNameIndex = 0; //name
            int columnValueIndex = 2; //description

            DataTable inputTable = new DataTable();
            foreach (string header in csv.HeaderRecord)
            {
                inputTable.Columns.Add(header);
            }
            while (csv.Read())
            {
                DataRow row = inputTable.NewRow();
                foreach (DataColumn column in inputTable.Columns)
                {
                    row[column.ColumnName] = csv.GetField(column.DataType, column.ColumnName);
                }
                inputTable.Rows.Add(row);
            }

            var outputTable = new DataTable();

            //Get the names of the columns for the output table
            var columnNames = inputTable.AsEnumerable().Where(x => x[columnNameIndex] != DBNull.Value && x[columnValueIndex] != DBNull.Value)
                                                            .Select(x => x[columnNameIndex].ToString()).Distinct().ToList();
            DataRow outputRow = outputTable.NewRow();

            //create the columns in the output table
            foreach (var columnName in columnNames)
            {
                outputTable.Columns.Add(new DataColumn(columnName));
            }

            //get all the rows in the input table
            var totalRows = inputTable.Rows.Count;

            //loop through the input table
            for (int n = 0; n < totalRows; n++)
            {
                //loop through each columnname for each row
                for (int i = 0; i < columnNames.Count; i++)
                {
                    //if it's the first loop we need a new row
                    if (i == 0)
                    {
                        outputRow = outputTable.NewRow();
                    }

                    outputRow[columnNames[i]] = inputTable.Rows[n][columnValueIndex].ToString();
                    //^^get the corresponding value from the input table

                  //confusion at this stage
                    if (i == columnNames.Count - 1)
                        outputTable.Rows.Add(outputRow);

                }
            }

           
        }
    }