I have following on a1

001. Andrew Fisher
(AUS)
002. Adam Kretschmer
(AUS)
003. Karen Richards
(AUS)


I need formula on b1 drag down to give me result as follows
, AUS in not only the country , the list is long enough

001. Andrew Fisher(AUS)
002. Adam Kretschmer(AUS)
003. Karen Richards(AUS)