the input and output should be similar

table a

col1 col2 col3

us 01/01/2012 10

us 02/02/2012 11

us 03/03/2012 33

gpb 01/01/2012 20

gbp 02/02/2012 21

chf 01/01/2012 30

output should be

us o3/03/2012 33 02/02/2012 11

gbp 02/01/2012 21 01/01/2012 20

chf 01/01/2012 30

in this chf is having only 1 record so, in output the the other cols are blank