Forum Discussion
Data duplicacy while UnPivotting data
Hi shishir999 ,
1. You could upivot the columns Act_Jan,Est_Jan,Diff_Jan,...,Act_Mar,Est_Mar,Diff_Mar in Query Editor.
2. Add conditional columns(optional). If you create this column, you could get your desired output like that in your image. If you don't create this custom column, you will get the output like this.
3. If you create the conditional column in Query Editor, you need sort by column under Data view.
4. Then you could create your desired matrix.
For more details about how to create the conditional column, you could refer to my attachment.
Best Regards,
Cherry
Hi shishir999 ,
1. You could upivot the columns Act_Jan,Est_Jan,Diff_Jan,...,Act_Mar,Est_Mar,Diff_Mar in Query Editor.
2. Add conditional columns(optional). If you create this column, you could get your desired output like that in your image. If you don't create this custom column, you will get the output like this.
3. If you create the conditional column in Query Editor, you need sort by column under Data view.
4. Then you could create your desired matrix.
For more details about how to create the conditional column, you could refer to my attachment.
Best Regards,
Cherry
Bingo....Thanks Cherry.
I was able to do the transformation i.e. in Step-2, but the Conditional column makes the magic.
Appreciated your help.
Regards
Shishir