changing data file structure

[Gene Shackman]

Hi all

Hi all

Hopefully easy question, but I don't know where to look. I have a table of data, like this:

country     year    population
AF          1950    12,004
AF          1951    12,430
AF          1952    13,432
up to AF 2009
AL          1950    3,211
AL          1951    3,234
AL          1952    3,326
up to AL 2009

the table lists a bunch of countries and population for each year. I'd like to change the form to look like this:

Country   pop1950   pop1951   pop1952  ... pop2009
AF         12,004      12,430      13,432
AL           3,211       3,234        3,326

and so on. Each country has one line per year. I'd like to change that so that each country has only one line with all the data on it.

Any easy way to do this? Can PSPP do this? All of the countries have the same number of years.

Thanks

Gene Shackman
more about me here
http://gsociology.icaap.org/report/whoare.html