Hi,
I need help to move Couple of Columns only to Rows result in order to have a tale prepared.
Headers - ID Country Customer Brewer Brand SubBrand OuterPackage InnerPackage ContainerVolume SKU Year Month Sales Sales_Promo Units Units_Promo Volume Volume_Promo
Value - 306 BE Intermarche BR.ROMAN ABD.VAN_ENAME BLONDE NA 6 X 0033.0 CL ABD.VAN_ENAME_BLONDE_BOUT_CAUT_6 X_0033.0 CL 2014 Apr 64 0 10 0 19.7 0
I need only couple of Headers to come to rows field like below
Measure Country Customer Brewer Brand SubBrand OuterPackage InnerPackage ContainerVolume SKU Year Apr
Sales BE Intermarche BR.ROMAN ABD.VAN_ENAME BLONDE NA 6 X 0033.0 CL ABD.VAN_ENAME_BLONDE_BOUT_CAUT_6 X_0033.0 CL 2014 64
Sales_Promo BE Intermarche BR.ROMAN ABD.VAN_ENAME BLONDE NA 6 X 0033.0 CL ABD.VAN_ENAME_BLONDE_BOUT_CAUT_6 X_0033.0 CL 2014 0
Units BE Intermarche BR.ROMAN ABD.VAN_ENAME BLONDE NA 6 X 0033.0 CL ABD.VAN_ENAME_BLONDE_BOUT_CAUT_6 X_0033.0 CL 2014 10
Units_Promo BE Intermarche BR.ROMAN ABD.VAN_ENAME BLONDE NA 6 X 0033.0 CL ABD.VAN_ENAME_BLONDE_BOUT_CAUT_6 X_0033.0 CL 2014 0
Volume BE Intermarche BR.ROMAN ABD.VAN_ENAME BLONDE NA 6 X 0033.0 CL ABD.VAN_ENAME_BLONDE_BOUT_CAUT_6 X_0033.0 CL 2014 19.7
Volume_Promo BE Intermarche BR.ROMAN ABD.VAN_ENAME BLONDE NA 6 X 0033.0 CL ABD.VAN_ENAME_BLONDE_BOUT_CAUT_6 X_0033.0 CL 2014 0
Bookmarks