A very elaborate workaround:

you could use the Export column to export each location to a seperate flat file (you'd need to combine all the data columns you need and then convert them to DT_TEXT). The name of the flat file will contain the name of the city.

After that, you can use a for each loop to loop over your newly generated flat files and do whatever you want to do with the data.