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
Can you paste the input as text which will be easy to copy and paste.
Many thanks
Shanker V
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 ?
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...):
User | Count |
---|---|
18 | |
14 | |
13 | |
9 | |
8 |