I have the following info in an IMPORT sheet:

Date	        route	City
2/1/2016	Albany	Latham
2/1/2016	Albany	Loudonville
2/1/2016	Albany	Albany
2/2/2016	Albany	Schenectady
2/2/2016	Albany	Voorheesville
2/2/2016	Albany	Schenectady
2/2/2016	Albany	Schenectady
2/2/2016	Albany	Schenectady
2/2/2016	Albany	Schenectady
2/2/2016	Albany	Hagaman
2/2/2016	Albany	Schenectady
2/2/2016	Albany	Latham
2/2/2016	Albany	Latham
2/3/2016	Albany	Chatham
2/3/2016	Albany	Hudson
2/3/2016	Albany	Catskill
2/3/2016	Albany	Schenectady
I have searched and have been unable to find a formula or some means to list the unique cities, based on matching the route and date - in a cell, separated by commas.

I am very sorry if the answer exists, but I have not found a solution in searching these forums or google.

I have another sheet with the following info and am looking to get the info in RED and listed like this:

A              B             C
Date	        Truck	       Areas Serviced
2/1/2016	Albany      Albany, Latham, Loudonville

Thank you in advance for any direction!