Transforming data in table to another shape

[AlteryxPrime666]

Hello,

I have table on left (1) and should transform it to the table on the right (2). What's the easiest way to do this? I know it's possible with transpose and summarize maybe, but I can't seem to find an easy way to do this. Thanks a lot for the help! 

[ShankerV · Accepted solution]

Hi @AlteryxPrime666 

One way of doing this.

Many thanks

Shanker V

[martinding]

Hi @AlteryxPrime666 

Please see attached:

[Yoshiro_Fujimori]

@AlteryxPrime666 ,

Yet another way of doing this:)

[AlteryxPrime666]

Thanks a lot for eveyone!