Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!

Need Help with Pivot Tables

6 - Meteoroid

Looking to make my data more manageable for a Tableau pull through and am looking to do a pivot like the example below. Not sure how to do this, if anyone could provide screenshots on how I can do it with the settings inside the tools that would be awesome! I know others use the transpose tools, but they are not providing the steps within the tool. Thank you, screenshots are below and an attachment is also provided. The 1st picture is my current data, the second is the want.


14 - Magnetar


Try using a Transpose tool, with Name and Person as Key fields, and see if that gets you close to what you need!

8 - Asteroid

hi a simple transpose tool will work here.


PFA the workflow