Transpose and change list with place, flags and different values

Question

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

Felipe_Ribeir0 · Answer

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/978794):

2 input data, bringing in a column based off a common value.yxmd

danielherzog · Answer

For sure:

PlaceIDNAMEFLAG

GER

123AAAredGER1000BBBredGER999YYYgreenUS123AAAredUS1000BBBgreen

Better ?

ShankerV · Answer

Hi @danielherzog

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

Many thanks

Shanker V