Want to transpose the data whenever new id is added

Hello Everyone,

I need some help to transpose the data whenever new id is added as new column.

Input:

output:

Appreciate your help!

Workflow

Accepted answers

@Ekmi9 One way of doing this

Please see attached workflow

If it solves the issue, please mark it as solved

@Ekmi9 One way of doing this