I have A datatable and want to convert in below datatable Id Gp SId Activity Ua 1 2 15 Helmet 4 2 3 16 Guard 5 3 6 17 Mask 8 Expected datatable Result: Helmet_GP Helmet_SId Helmet_Activity Helmet_Ua Guard_Gp Guard_SId Guard_Activity Guard_Ua Mask_Gp Mask_Sid Mask_activity Mask_Ua 2 15 Helmet 4 3 16 Guard 5 6 17 Mask 8

In C#, use the following code to get your desired result: public void ShowResult() { DataTable sourceTable = resultDS.Tables[0]; DataTable finalTable = new DataTable(); finalTable.Rows.Add(); for ( int i = 0; i { var Activity = sourceTable.Rows[i][ "Activity" ]; for ( int j = 1; j { var colName = sourceTable.Columns[j].ColumnName; var colNameVal = sourceTable.Rows[i][j]; if (colName == "Activity" ) finalTable.Columns.Add(Activity + "_" + colName, typeof ( string )); else finalTable.Columns.Add(Activity + "_" + colName, typeof ( int )); finalTable.Rows[0][Activity + "_" + colName] = colNameVal; } } } Final Result: