Transforming data from horizontal to vertical
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
HI,
Trying to perform some data transformation, pretty stumped as I'm still new to Alteryx.
My data set looks like this:
Need to transform it so it looks like this:
Any help would be appreciated.
Thanks
Solved! Go to Solution.
- Labels:
- Transformation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Uali,
You will have to use the transpose tool. Please refer to this Tool Mastery article. You can also right click on the tool and select "Show Example" for further detail.
https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Transpose/ta-p/89741
Hope this helps If does, can I ask you to mark it as the solution? this will help other users to find it and will allow us to close the thread. If doesn't, you could upload your data and I can show it with a workflow.
Many thanks!
Best,
Diego
