Pivoting Columns

[Mohamed_Kamel]

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 annoying since I cant benifit from them being in the same raw to do comparisons. Here is the photo.

Please help me it is super important. I already do with th pivoting the "Don't aggregate" option.

Thanks in advance.

[Daniel29195]

@Mohamed_Kamel 

can you share the intial structure of your table with some dummy data. 

that would be helpful

best regards

[Mohamed_Kamel]

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