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.
Solved! Go to Solution.
Hi,
Try using a Transpose tool, with Name and Person as Key fields, and see if that gets you close to what you need!