Similar to Rory's , but doenst require a ROW_NUMBER

SELECT OutTab.title ,OutTab.[subtitle] ,

Cities =

STUFF ( ( SELECT ','+InrTab.value

FROM [test12] InrTab

WHERE InrTab.title = OutTab.title

AND InrTab.subtitle = OutTab.subtitle

ORDER BY InrTab.value

FOR XML PATH(''),TYPE

).value('.','VARCHAR(MAX)')

, 1,1,SPACE(0))

FROM [test12] OutTab

GROUP BY OutTab.title , OutTab.[subtitle] ;