You need to use the Unpivot transformation.

How To Use the Unpivot Data Flow Transform in SQL Server Integration Services SSIS[/url]

The unpivot however accepts only a fixed number of columns as input though. So you have to make sure the city column is splitted into multiple columns and that this number is fixed.

If this is not possible, you'll have to implement it with a script component.