You beat me to it by minutes!

SELECTT1.TranID,

(

SELECTOriginCode + DestinationCode

FROM#Test T2

WHERET2.TranID = T1.TranID

ORDER BY

OriginCode

FOR XML PATH('') ) TheString

FROM#Test T1

GROUP BY

TranID ;