0

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?

Shaido
  • 25,575
  • 21
  • 68
  • 72

0 Answers0