This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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