Hi,
Assume that this is an excel sheet,
header--- ItemCode Cost Quantity
1 20 5
2 40 1
1 20 3
i want to load the excel sheet to gridview using import,
it will load all the three column instead of that i want to check the condition that
itemcode is same mean i want to merge that two column into single one in gridview like this,
ItemCode Cost Quantity
1 20 8
2 40 1