Append rows as colums if ID is equal

Question

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.

TEST.yxmd

Emil_Kos · Accepted Answer

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.