Forum Discussion
Pivoting Columns
I am trying to pivot 12 coloumns into two coloumns of Actual value and Target value. The thing is it is pivoted in two different raws, having 12 raws of actual then 12 raws of target. and it is annoy...
can you share the intial structure of your table with some dummy data.
that would be helpful
best regards
Hello,
It is like this but much bigger, I first unpivot the months colouns then pivot the target actual so I have the coloumn of Months then Target Then actual. But then the Target and actual are separated in different coloumns like my first photo in the original post.
Thanks a lot
| Source.Name.1 | KPI code | Year to day average. | Target-Actual | January | February | March | April | May | June | July | August | September | October | November | December |
| Plant 1 | L9 | 5 | Target | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 |
| Plant 1 | L9 | 3 | Actual | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 |
| Plant 2 | L9 | 156787 | Target | 14150 | 12757 | 14497 | 14389 | 14400 | 13755 | 14446 | 6033 | 14313 | 13679 | 14290 | 10078 |
| Plant 2 | L9 | null | Actual | 14106,8 | 14220 | 15221,5 | 13816 | 15371 | 13034 | 13796,25 | 6348 | 13369,5 | 14292 | 0 | 0 |