Forum Discussion

n8schicht's avatar
n8schicht
Helper I
5 years ago
Solved

Transform Data - transpose unique row into column

Hello,

 

I have the following dates:

 

How can I change this with the help of Power Pi so that I only get one line per item number and the values are then transposed into several columns per item number

 

note: the sampletext is a sample for text.... so normal there would be normal text inside...

 

like this:

 

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    try this

     

     

     

    you should get this

     

     

     

    starting from this

     

     

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    try this

     

     

     

    you should get this

     

     

     

    starting from this

     

     

    • n8schicht's avatar
      n8schicht
      Helper I
      5 years ago

      You solved it correctly according to the description I described above. But I think that I expressed myself wrongly here. It's about a table that looks like this:

       

      And the result should then look like this:

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    If you want to have quick and relevant answers, you should:

    • relevant : explain in detail the logic of the transformation you want to carry out (providing significant examples);
    • quick:  upload on the site (or on dropbox or similar) some files/tables that can be easily copied;
    • other useful things 😁
    • n8schicht's avatar
      n8schicht
      Helper I
      5 years ago

      yes you are right, i also noticed, i will of course improve myself with further questions!