Forum Discussion

SebSchoon1's avatar
SebSchoon1
Post Patron
4 years ago

UnPivot Columns But also Keep these columns in table

Hi Guys,

 

I have some chinese head breaker here ^^

 

Is it possible to Unpivot columns ( from a specific list of columns) 

 

But also keep these columns in the tables ? 🙂

 

= Table.Unpivot(#"On Transforme les entetes inclus dans la liste en texte",#"Detection des Tailles 11 On garde une liste","Tailles","Quantités")

 

but i want also to keep the informations 

Need Help

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi SebSchoon1 .

    You can copy the columns which you want to Unpivot and keep the original columns as it is.


    If this post helps, then mark it as "Accept as Solution" and give it a thumbs up.

    • SebSchoon1's avatar
      SebSchoon1
      Post Patron
      4 years ago

      Hello 🙂 

       

      I'm sorry but I don't understand 🙂

    • SebSchoon1's avatar
      SebSchoon1
      Post Patron
      4 years ago

      Hello, 

       

      You mean, 

       

      In my list of columns to keep. Just add the columns I also unpivot?

    • SebSchoon1's avatar
      SebSchoon1
      Post Patron
      4 years ago

      Anonymous Hello,

       

      I am not able to find the solution, 

       

      In the table i want to pivot, i'd like to keep also the columns i'm unpivoting.

       

      in my formula here below, the first part, is the table i want to unpivot, in the second part these are the clothes sizes i'd like to unpivot, but also to keep in columns.

      is this feasible?

       

      = Table.Unpivot(#"On Transforme les entetes inclus dans la liste en texte",#"Detection des Tailles 11 On garde une liste","Tailles","Quantités")