Transpose a DataTable using C#

private DataTable TransposedTable(DataTable inputTable)

{

DataTable TransposedTable = new DataTable();

// Add columns by looping rows

// Header row's first column is same as in inputTable

TransposedTable.Columns.Add(inputTable.Columns[0].ColumnName.ToString());

// Header row's second column onwards, 'inputTable's first column taken

foreach (DataRow inRow in inputTable.Rows)

{

string newColName = inRow[0].ToString();

TransposedTable.Columns.Add(newColName);

}

// Add rows by looping columns

for (int rCount = 1; rCount <= inputTable.Columns.Count - 1; rCount++)

{

DataRow newRow = TransposedTable.NewRow();

// First column is inputTable's Header row's second column

newRow[0] = inputTable.Columns[rCount].ColumnName.ToString();

for (int cCount = 0; cCount <= inputTable.Rows.Count - 1; cCount++)

{

string colValue = inputTable.Rows[cCount][rCount].ToString();

newRow[cCount + 1] = colValue;

}

TransposedTable.Rows.Add(newRow);

}

return TransposedTable;

}