Dear all,

I need to "re-shape" some data automatically, but I don't know how to do it.

The format of my data is the following:

Code:
    Year Country1 Country2 Country3
    1800 1        2        3
    1900 3        2        1
    2000 6        6        6
And I need to transform it to:
Code:
    Country# Year Value
    Country1 1800 1
    Country1 1900 3
    Country1 2000 6
    Country2 1800 2
    Country2 1900 2
    Country2 2000 6
    Country3 1800 3
    Country3 1900 1
    Country3 2000 6
Do you have any idea / script or solution to do it? I am not an expert.

Thank you for your attention.