Transpose and change list with place, flags and different values

[danielherzog]

Hallo,

I have to transpose a list depending on a flag and a location and different properties (ID and name).
Then the table should show the respective location on the left and the property on the top.
Here is the simplified original list:

After the transposition the matrix should look like this:

Maybe one of you can help me or show me a similar forum post.

Thanks and greetings

[ShankerV]

Hi @danielherzog 

Can you paste the input as text which will be easy to copy and paste.

Many thanks

Shanker V

[danielherzog]

For sure: 

Place	ID	NAME	FLAG
GER	123	AAA	red
GER	1000	BBB	red
GER	999	YYY	green
US	123	AAA	red
US	1000	BBB	green

Better ?

[Felipe_Ribeir0]

Hi @danielherzog 

One way of doing this (using this great post made by @atcodedog05 as reference btw: https://community.alteryx.com/t5/Engine-Works/How-to-Create-Merged-Cells-in-Reports-Part-2/ba-p/9787...):