Converting Vertical Data to Horizontal

If there's always three values for each country, try this...

Assuming the data starts in A1...

in D1 enter =C1
in E1 enter =C2

Then copy D1:E3 and paste down the sheet.

Copy columns D and E and Paste Special values only.

Now select columns A to E and sort by column D and column E

The data for columns D and E should be at the top of the sheet
and the blank D and E rows should be at the bottom of the sheet.

Delete the blank D and E rows.

Delete column B

Insert a row and enter the y1 y2 y3 header row

...and I think that should be it.

I got a funny feeling you're gonna tell me that there's not always three values for each country in which case this won't work