I want to merge two data sheets with different columns in c#..
Based on my sheets and column mention, it should merge the data and display in final output as datatable.
Sheet1 ==> columnA data and columnC data
sheet3 ==> columnD data and Column F data
datatable result ==> merge of ColumnA & ColumnC as one column
merge of ColumnD & ColumnF as another column
my input string is sheet and column.
inPut string Sheets ==> "Sheet1" and "Sheet3"
Input string Columns ==> ColumnA & ColumnC(Sheet1)
ColumnD & ColumnF(Sheet3)...
How to form code in either LINQ or C#..?