Page 1 of 1

How can I stack data into pivot form

Posted: Tue Jan 08, 2019 2:36 am
by chairake
Hi,

I would like to know is there a way to command time series data into stack data like pivot form as example below

If I can command directly to simple platform as I show in the picture please tell me.

thank you so much

Chairat

-----------------------------------------------------------------------------------------
I have 3 form of sale data in different material and region
vol_(*)_(**)
Growth_(*)_(**)
MA3_(*)_(**)

while (*) are names of material that are a,b,c,d
(**) are region that are wk,me,e,w,n,ne,s

Here is the stack data form I want
ID01 Var01 (Material) Var02 (Region) Vol Growth MA3
2000m1 A wk 100 2% 1%
2000m2 A wk 110 1% 0%
...
...
...
2018m12 A wk 200 5% 0%
2000M1 B wk 500 4% -3%
.....

and so on