Hi All,
I need to transpose data similarly to excel can some one help on this.
Many thanks for your help
Input
Name | Year | Std | V1 | V2 |
A | 2018 | NORM | Yes | Yes |
B | 2018 | NORM | Yes | Yes |
C | 2018 | NORM | Yes | Yes |
D | 2018 | NORM | Yes | Yes |
E | 2018 | NORM | Yes | Yes |
F | 2018 | NORM | Yes | Yes |
Desired Output
Name | A | B | C | D | E | F |
Year | 2018 | 2018 | 2018 | 2018 | 2018 | 2018 |
Std | NORM | NORM | NORM | NORM | NORM | NORM |
V1 | Yes | Yes | Yes | Yes | Yes | Yes |
V2 | Yes | Yes | Yes | Yes | Yes | Yes |
Solved! Go to Solution.
A development possibility...... add a single tool or parameter for "Excel transpose"? Students find it frustrating to have a transpose tool that is unlike their familiar transpose tool.
Thanks - can you please provide a url? I searched for and couldn't find this. And interestingly, there are MANY posts about this issue in the discussions and several very helpful work--around solutions.
Hi, @Present_guy
here you are.
https://community.alteryx.com/t5/Public-Community-Gallery/Transpose-Excel-style/ta-p/904150