Forum Discussion

ancorte's avatar
ancorte
Frequent Visitor
2 years ago
Solved

Unpivot several columns with attribute and value

Hello, i have a table with several columns, like this: So i have in a row a Code Article, and in the same row the code of Material1, the Quantity of Material1, the code of material2, teh Qauntity of...
  • Dangar332's avatar
    2 years ago

    i take these example

     

    ok problem solve follow below step

    1. select  ID Articolo and unpivote other column

    2.  replace value  code mat1,  code mat2,  code mat3,  code amt4 to code

        and qt mat1,  qt amt2,  qt amt3,  qt mat4  to qt

    3.  add conditional column like these

    which look like these  

     

    4. add another conditional column like these

    5. copy  qt  column and paste to new table(qt table) and add index column which look like below

    6.  now return to original table and add index to original table 

    7. now merge original table and qt tqble 

    8.  now expand table  click on rounded(red) area 

    by clicking red area open interface and from that unselect index column

    press ok which look like these

    9.  change qt table name to qt and select Id Articolo, code and qt and remove other column and it look like these

    10. now filter table and which show those value non-null value 

    and it look like these

     

    here solution done 

    don't get  confuse with values because i take some different value from you but following my step you got your answer here t attach step screenshort for comfortness 

    close and apply from home tab and paly with it

     

    Did i answer your question? Mark my post as a solution which help other people to find  fast and easily.