Hello Simon,
One way would be to set up a Pivot Table. This is probably the easiest.
If you wanted to use formulae, assuming that your table starts in cell A1, the following in M2/N2,O2 and copied down would work.
=OFFSET($A$1,MATCH("Germany",$A:$A,0)-1+ROW()-ROW(M$2),1)
=OFFSET($A$1,MATCH("Germany",$A:$A,0)-1+ROW()-ROW(M$2),2)
=OFFSET($A$1,MATCH("Germany",$A:$A,0)-1+ROW()-ROW(M$2),3)
You could make it more general by substituting a cell reference for the string and entering the country into that cell or by setting up a drop-down list of the country names.
Hope this helps but get back if you need more.
Harry