Group Common Row cells as comma separated in DataTable using C# .Net

Hi,

I refereed you article on exporting the values from grid view to excel from the below URL

http://www.aspsnippets.com/Articles/Export-GridView-Data-to-Excel-using-OpenXml-in-ASPNet.aspx

My doubt is If the Country is the same and the names are different in the column then how to export it in the excel like the 2nd table in excel with the names combined.

Pls help in this sir...