I am trying to get the buffer data into an excel file which will multiple tabs. So for example, if the buffer day has employee data with one of the field/column being the city, I would want individual tabs for each city and the employee information in it. So the tab Boston would have all the employees living in Boston. The column "City" can have any number of cities, so this is a dynamic field.

The approach I want to take is first all loop through the values in the "City" column and save the unique values to an array. Once we get the unique values loop through the data again and save the rows to its corresponding cites. I am new to C# language, but any pointers would be greatly appreciated.