Transform Data - transpose unique row into column

[n8schicht]

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:

[Anonymous]

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]

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

[Anonymous · Accepted solution]

try this

you should get this

starting from this

[n8schicht]

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: