Append rows as colums if ID is equal

[BautistaC888]

Hello,
I have a Database similar to this

And i want to transform it into this

Appending the rows as columns if they are equal.
I added a workflow with the input and desired output.
Thank you.

[Emil_Kos · Accepted solution]

Hi @BautistaC888,

I think this solution should work for you.

The only downside is you need to manually arrange the column order but besides that, I think it works as you wish:

If this isn't good for you let me know.