Forum Discussion

Taga0228's avatar
Taga0228
New Member
1 year ago
Solved

How to Unpivot column with formular

  ID Code Carrier Code AD Collection AD Bill of lading AD Filing Charge AD Ocean Freight AD Surcharge for Cape of Good Hope routing AD Supplier competing offer Type 474561 77084 001...
Need Help
  • govind_021's avatar
    govind_021
    1 year ago

    Hi Taga0228 
    It is there 
    Go to Transform Tab in the ribbon and there you will get unpivot columns options i tried and its working fine 
    select all cost column while pressing ctrl key and select "unpivot" columns 
    name value column as a Cost 
    please refer below image

     

govind_021's avatar
govind_021
Icon for Super User rankSuper User
1 year ago

Hi Taga0228 
It is there 
Go to Transform Tab in the ribbon and there you will get unpivot columns options i tried and its working fine 
select all cost column while pressing ctrl key and select "unpivot" columns 
name value column as a Cost 
please refer below image