I want to convert this:
Col Year Func Period Act header Spain Germany
xy 2013 F1 Per Act1 Price 1000 4000
xy1 2013 F2 Per Act1 Price 2000 5000
xy2 2013 F3 Per Act1 Price 3000 6000
To:
Year Func Period Act header Country Price
2013 F1 Per Act1 Price Spain 1000
2013 F2 Per Act1 Price Spain 2000
2013 F3 Per Act1 Price Spain 3000
2013 F1 Per Act1 Price Germany 4000
2013 F2 Per Act1 Price Germany 5000
2013 F3 Per Act1 Price Germany 6000
How can this be done?